Thanks, Ashish.. I've sortout this one.. thanks A Lot Bro..!! :-) On Mon, Mar 28, 2011 at 11:24 AM, ashish koul <koul.ash...@gmail.com> wrote:
> note: before you start slide show run StartEvents macro in ppt > > On Mon, Mar 28, 2011 at 11:18 AM, ashish koul <koul.ash...@gmail.com>wrote: > >> hi deepak >> >> try this method see if it helps you >> >> select the month from combo box in ppt it will update the chart in ppt >> as well as in excel >> >> >> >> open ppt press alt f11 change the location of workbook >> >> >> also always keep chart in a blank worksheet >> >> On Sun, Mar 27, 2011 at 3:44 PM, Rajesh Kunder <kunder....@gmail.com>wrote: >> >>> Hi, let me re-iterate your problem. You are trying to copy data from >>> excel sheet and put it into a linked excel sheet in the PPT to create >>> graphs right? This can be done in VBA using OLE objects but >>> unfortunately we cannot do it in Excel 2007 as this feature has been >>> taken off. Having said that you can definitely do this in earlier >>> versions of Excel. >>> >>> On 3/27/11, Deepak Pal Singh <deepaktheind...@gmail.com> wrote: >>> > Hi Ashish, >>> > >>> > I'd attached the PPT in my last mail & you can find the charts source >>> data >>> > in the embedded excel file. You need to right click on the chart & then >>> > click on edit option.. >>> > >>> > Thanks.. >>> > >>> > On Sun, Mar 27, 2011 at 11:21 AM, ashish koul <koul.ash...@gmail.com> >>> wrote: >>> > >>> >> can you attach the source data as well >>> >> >>> >> >>> >> On Sun, Mar 27, 2011 at 9:58 AM, Deepak Pal Singh < >>> >> deepaktheind...@gmail.com> wrote: >>> >> >>> >>> Hi Guy's, >>> >>> >>> >>> I'm still waiting for your help... >>> >>> >>> >>> ---------- Forwarded message ---------- >>> >>> From: Deepak Pal Singh <deepaktheind...@gmail.com> >>> >>> Date: Sat, Mar 26, 2011 at 7:55 PM >>> >>> Subject: $$Excel-Macros$$ Edit Data In Embedded Excel Charts Within >>> >>> Powerpoint Using VBA >>> >>> To: excel-macros@googlegroups.com >>> >>> >>> >>> >>> >>> Hi Guy's, >>> >>> >>> >>> I need your help, I’ve a PPT with embedded an excel file. I want to >>> show >>> >>> the chart given on the sheet1 of the embedded workbook on my PPT. My >>> >>> chart >>> >>> has dynamic range whenever I change the month on from the cell “H1” >>> on >>> >>> the >>> >>> sheet1 the source data gets changed according to the table given on >>> the >>> >>> same >>> >>> sheet. Now I want the same functionality in PPT as well, I’ve tried >>> and >>> >>> write a code to do this, however I’m getting wrong somewhere, I’m not >>> >>> able >>> >>> to find what I’m missing..Getting an error message during compilation >>> >>> “OLEFormat (unknown member): Invalid request. This property only >>> applies >>> >>> to OLE objects”, please go through my code and solve my problem. >>> >>> >>> >>> >>> >>> >>> >>> Thanks & Regards >>> >>> >>> >>> Deepak >>> >>> >>> >>> -- >>> >>> >>> >>> >>> ---------------------------------------------------------------------------------- >>> >>> Some important links for excel users: >>> >>> 1. Follow us on TWITTER for tips tricks and links : >>> >>> http://twitter.com/exceldailytip >>> >>> 2. Join our LinkedIN group @ >>> http://www.linkedin.com/groups?gid=1871310 >>> >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> >>> Like our page on facebook , Just follow below link >>> >>> http://www.facebook.com/discussexcel >>> >>> >>> >>> -- >>> >>> >>> >>> >>> ---------------------------------------------------------------------------------- >>> >>> Some important links for excel users: >>> >>> 1. Follow us on TWITTER for tips tricks and links : >>> >>> http://twitter.com/exceldailytip >>> >>> 2. Join our LinkedIN group @ >>> http://www.linkedin.com/groups?gid=1871310 >>> >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> >>> Like our page on facebook , Just follow below link >>> >>> http://www.facebook.com/discussexcel >>> >>> >>> >> >>> >> >>> >> >>> >> -- >>> >> *Regards* >>> >> * * >>> >> *Ashish Koul* >>> >> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >>> >> *akoul*.wordpress.com <http://akoul.wordpress.com/> >>> >> My Linkedin Profile < >>> http://in.linkedin.com/pub/ashish-koul/10/400/830> >>> >> >>> >> >>> >> P Before printing, think about the environment. >>> >> >>> >> >>> >> -- >>> >> >>> >> >>> ---------------------------------------------------------------------------------- >>> >> Some important links for excel users: >>> >> 1. Follow us on TWITTER for tips tricks and links : >>> >> http://twitter.com/exceldailytip >>> >> 2. Join our LinkedIN group @ >>> http://www.linkedin.com/groups?gid=1871310 >>> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >> >>> >> To post to this group, send email to excel-macros@googlegroups.com >>> >> >>> >> <><><><><><><><><><><><><><><><><><><><><><> >>> >> Like our page on facebook , Just follow below link >>> >> http://www.facebook.com/discussexcel >>> >> >>> > >>> > -- >>> > >>> ---------------------------------------------------------------------------------- >>> > Some important links for excel users: >>> > 1. Follow us on TWITTER for tips tricks and links : >>> > http://twitter.com/exceldailytip >>> > 2. Join our LinkedIN group @ >>> http://www.linkedin.com/groups?gid=1871310 >>> > 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> > >>> > To post to this group, send email to excel-macros@googlegroups.com >>> > >>> > <><><><><><><><><><><><><><><><><><><><><><> >>> > Like our page on facebook , Just follow below link >>> > http://www.facebook.com/discussexcel >>> > >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> >> >> -- >> *Regards* >> * * >> *Ashish Koul* >> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >> *akoul*.wordpress.com <http://akoul.wordpress.com/> >> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> >> >> >> P Before printing, think about the environment. >> >> >> > > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > P Before printing, think about the environment. > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
