Hello,
I am also trying to do the same thing. But instead of an .xls file it a PowerPoint one. I am using a macro to add a PowerPoint file as an object.
The file's name is also a date. What is the equivalent of WorksheetFunction.Text(TheDate, "YYYY_MM_DD") function in VBA for PowerPoint?
I would appreciate your help.
Bookmarks