Excel export to Powerpoint VBA code

[bahllr]

I have a number of charts that I would like to copy and paste into a powerpoint presentation. In order to do this, I need to know how to advance the powerpoint slides with each new copy/paste action.

I currently have code that exports the charts to excel after opening the right powerpoint file. Unfortunately, I can't figure out how to increment/advance the powerpoint slides.

Does anyone know how I can do this? If so, the generic code to advance slides and paste something to it would help me TREMENDOUSLY!

Thanks,

Ben

 

[MorganO]

Use the following code:

Application.ActivePresentation.Slides(1).Select

Where:

- Application is the powerpoint application
- 1 is Slide number 1, etc.

and something like the following for the pasting:

Application.ActivePresentation.Slides(1).Shapes.Paste

Take care,

Owen