Don’t know if this is the correct forum, but I’m sure you’ll point me in the right direction…
A colleague asked me if it was possible to programatically step through all the embedded PowerPoint objects in an Excel Worksheet and save them as separate PowerPoint files.
I’ve got as far as:
Set ppObj = Worksheets(“Sheet1”).OLEObjects(1)
ppObj.Activate
With ppObj.Object.
but can’t figure out how to get a handle on the actual object to instruct it to saveas and then close.
Any pointers?
TIA