Add Month Name to Title via macro
Good Morning,
I am working on a project that automatically generates reports in PowerPoint. Essentially I have an excel spread sheet that queries a database, pulls in the data, opens a PowerPoint template, builds tables in Powerpoint based upon the data in the sheets, and then saves out the Powerpoint presentation as a new file.
Each slide in the template has some various header information. One item of information that it must contain is the Month and Year the data was generated.
Is there some way possible to, in the header block, have the name of previous month apear automatically based on the system date?
|