I'm using the following code to copy an Excel chart to a PowerPoint slide. It works fine when I copy the chart to slide 1. However, I cannot figure out how to copy the chart to any slide other than slide 1. Any help would be greatly appreciated.
Please Login or Register to view this content.
Last edited by vlady; 10-11-2012 at 09:35 PM.
Try this macro:
ArtikPlease Login or Register to view this content.
vlady - Thanks for pointing out the rules. As you noticed, I'm a newcomer to this forum. I'll do better in the future.
Artik_PL - Thanks for your help. I'm still getting the following error on the "activeSlide.Shapes.PasteSpecial(link:=msoFalse).Select" statement whenever I enter a number other than 1:
Run-time error '-2147188160 (80048240)' : ShapeRange (unknown member) : Invalid request. To select a shape, its view must be active.
I'm using PowerPoint 2010 and Excel 2010. Does the code need to be different for these versions?
Can you show an example of both files in the attachment?
Artik
Artik_PL - Attached is the xlsm file. The forum uploader won't allow me to upload the Powerpoint file, but it's a very basic Powerpoint 2010 file with 3 slides. Each slide is blank except for a title.
Powerpoint file attach in zip file.
Artik
Thanks for recommending the zip file.
Full code in standard module:ArtikPlease Login or Register to view this content.
Artik_PL - Thank you for solving this problem for me. Your solution is perfect!
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
HTH
Regards, Jeff
Jeff - Thanks for the guidance about marking the thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks