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
