linking excel to powerpoint

Hi,

I have a range of data in various worksheets which I need to copy on to different excel slides. After my 1st copy-paste operation from the 1st worksheet to the 1st ppt slide, I want to the select the next slide as the active slide for the paste operation. How do I do this?

Thanks.

Here is the macro Im using:

Please Login or Register  to view this content.

This is for the 1st excel sheet. Say I have 3 sheets with similar macros for each. I have a main sub in which I am calling these macros:

Please Login or Register  to view this content.

Ive set the 1st slide as the active slide for the 1st macro. I need to set the 2nd slide as the active for the 2nd macro, the 3rd slide as active for the 3rd macro and so on. Any ideas on how to do this?

Please help me out here. Ive been stuck on this for a long time.

Hi,

I have an excel workbook with some sheets which have charts that i need to paste onto a pp presentation. I want to paste each chart on a new slide. Im facing a problem selecting a different slide to be active for each worksheet. For eg., I want slide 1 to be active for pasting a chart from sheet1, slide 2 for sheet 2 and so on. Is there a way I can select my active slide according to its number? How exactly should i do it?

Please help me here. Im stuck.