Jenise


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




Re: Automating PowerPoint

Jenise


Hello,

Does anyone have any ideas on this It must be possible to do.

thanks,

Jenise






Re: Automating PowerPoint

Andy Pope

Powerpoint, unlike excel and word, does not have AutoOpen routine unless the file is an addin.
See Shyam Pillai's page for more details.

AutoEvents Add-in for PowerPoint 2000 and later
http://skp.mvps.org/autoevents.htm

As for having the file run at set times have a look at the help on Schedule in XP which says,

"To open Scheduled Tasks, click Start, click All Programs, point to Accessories, point to System Tools, and then click Scheduled Tasks."







Re: Automating PowerPoint

Jenise

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





Re: Automating PowerPoint

Andy Pope

One possible way around the limitations of Powerpoint is to use Excel to automate powerpoint.
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