Okay, Thanks For Your Help.. Rajesh.. 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 > -- ---------------------------------------------------------------------------------- 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
