I have already posted a query like this before but dint get a response...so im trying my luck again.

I have some worksheets in a workbook which contain some charts which I have to copy onto a powerpoint presentation. I have to copy one chart onto one slide and then the next chart from the next sheet onto the next slide and so on. Im using a macro which selects either the current slide as active slide (i.e. copies all the charts onto one slide) or appends the slides to the end of the presentation. This isnt what I want and i am trying to figure out if I can select the active slide in that presentation by slide number. Unfortunately I havent been able to do it.
Any ideas on this would be appreciated. Thanks.

P.S.: Here is the macro i am using

Please Login or Register  to view this content.