Excel to Powerpoint - VBA Autodate/AutoPagenum

dr_drews

New Member
Joined
Dec 18, 2004
Messages
16
Hi, I know this is possibly more of a powerpoint question but thought I'd try my luck here...

I have a macro that takes data from an excel file and creates a powerpoint file using the data from Excel. All is working well, but last bit I want to add is to insert the date and slide number at the bottom of the slide that has been created.

You can do this manually in Powerpoint 2007 by going to the Insert tab on the ribbon and clicking Date or Slide Number... but, I can't work out how to do this with VBA!

Any help appreciated!
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,109,454
Messages
5,528,862
Members
409,841
Latest member
Orval_Effertz
Top