I have a vba procedure within a ppt presentation that creates a new presentation with a set of slides and saves it. This process is repeated until about 30 different presentations are created, but I would like to automatically execute it at a specific time so I don't have to run the code manually everyday.
Can you please suggest how I can automically execute my vba code to run
thank You!
Jenise
Automating PowerPoint
Sai A
As Excel workbooks support the AutoOpen event.
You will need to port your code over to excel. And within the code create a reference to Powerpoint. No doubt your code will require other changes in order to work. Whether the effort of changing code compared to manually running is worth it, only you can decide.
Some thing like this, which requires a reference to the PowerPoint library.
Dim objPPT As PowerPoint.Application
Set objPPT = CreateObject("Powerpoint.application")
objPPT.Visible = True
Jacco Mintjes
See Shyam Pillai's page for more details.
AutoEvents Add-in for PowerPoint 2000 and later
As for having the file run at set times have a look at the help on Schedule in XP which says,http://skp.mvps.org/autoevents.htm
"To open Scheduled Tasks, click Start, click All Programs, point to Accessories, point to System Tools, and then click Scheduled Tasks."
vijaygill
I'm trying to get the Add-In to work but am having some problems. I created the Add-in, but I only want it to work for those specific presentations and not for every presentation I work with. I also only want it to run only once. Once my macro runs and saves the presentations on the drive, I went back and opened the saved ppt files and the macro re-ran itself again.
Has anyone else had this issue and how did they resolve it How do I make sure my add-in only applies to once
thanks,
Jenise
PrasadC
Hello,
Does anyone have any ideas on this It must be possible to do.
thanks,
Jenise