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

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

"Eddy" wrote in message
...
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

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

Eddy

"NickHK" wrote:

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

"Eddy" wrote in message
...
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