VBA to edit PowerPoint presentation

[Dr. Demento]

First of all, if any one knows of a good PowerPoint VBA resource (coding in either from ppt or XL), I'd be very appreciative.

I apologize for not having any code, but I don't know where to start with this. Not even sure if all of this is possible, but you don't know until you ask, eh?

On a weekly basis, I prepare a number of workbooks, one of has linked charts to a powerpoint presentation (2010, .pptx).
From Excel, I would like to:

1. Open .pptx file
2. Update linked charts (6 have automatic updates, 2 have manual updates - this can be changed, if needed)
3. Change a date listed in a text box listed on first slide
4. Save file
5. Edit all Links to Manual update (or Break link - either way)
6. SaveAs backup with date (yyyymmdd) of .pptx
7. Close original file without saving || Close backup if still open

I guess this could all be done in Powerpoint if necessary; the only stipulation is that the backup needs to be a .pptx format, not .pptm.

Thanks y'all!

 

[Rijnsent]

Hi Dr Demento,
what you want is definitely possible, I don't have all code present, but found some helpful links that might get you started:
https://msdn.microsoft.com/en-us/library/office/ee814734(v=office.14).aspx
Using Excel with Other Office Applications
As a start: there is no macro recorder in PowerPoint, but I would start coding there, as the objects are present there (in Excel I generally have a harder time finding the right elements).
Hope that gets you started, don't hesitate to post code here if you get stuck.
Cheers,
Koen

 

[Dr. Demento]

Rijnsent,

Thank you for the sources and advice! I will see what kind of damage I can do and I'll be back!

Dr. D