Save Excel File based on Opened PPT File

[MHamid]

Hello,

I'm looking for a vba code that would save an excel file based on an open PPT file. Is this possible?


Thank you

 

[MHamid]

Not sure if I'm being clear enough, but what I want to do is save the excel file as the same name of the open PPt filename plus the current date. I can get the current date without a problem, but I can't seem to figure out the vba code to look at the open PPT presentation, get that filename and save excel with that filename plus the current date.

For instance, the PPT filename could be Checklist_Checker_Feb_2018. Therefore, I need the macro to see that name, retrieve it, and use that exact name plus the current date (Checklist_Checker_Feb_2018_04122018.xlsx). Is this possible within excel or within powerpoint?

Thank you