View Single Post
 
Old 08-27-2013, 07:02 AM
bremen22 bremen22 is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Jul 2013
Posts: 44
bremen22 is on a distinguished road
Question 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?
Reply With Quote