Excel to Powerpoint Office 03 with VBA

[Tino1207]

Hi I'm trying to develop a VBA macro which from an Excel workbook will automatically open up powerpoint and paste onto identified slides various graphs and commentary boxes.

I've searched a lot of the web and have found various bits of code, but dont seem to be able to get them to work...

Ideally im first looking to find some code which identifies opening and creating a powerpoint.

Then some seperate code which allows for the copying from excel over into powerpoint....

any help much appreciated.

 

[Andrew Poulsom]

This should get you started:

http://peltiertech.com/Excel/XL_PPT.html

 

[Tino1207]

Thanks.

I've seen code like this before, but seem to keep having the same problem.

Sub ExcelToNewPowerPoint()
Dim PPApp As PowerPoint.Application
Dim PPPres As PowerPoint.Presentation
Dim PPSlide As PowerPoint.Slide

At the stage highlighted red I get the message

"Compile Error:

User-defined type not defined"

I don't really understand what this means / have I done something wrong?

 

[Tino1207]

Think I've figured it out, I had selected Office Object Library not Powerpoint