VBA calling ppt

[Guest]

Is there a VBA in Excel that opens a Powerpoint file (master file that links
into Excel files), does the links automatically, break the links (to retain
the values and charts) and save the ppt file as a Pastevalue version ppt?

Cheers
Eddy

 

[NickHK]

Eddy,
Record a macro in PowerPoint for these action.
Transfer the code to Excel, using the PPTApp object:
Dim PPTApp as powerpoint.application

Set PPTApp = new powerpoint.application

with pptapp
... you recorded and corrected code here
end with

NickHK

 

[Guest]

Thanks Nick! This looks easy. Will try it out.

Eddy