Powerpoint Automation

  • Thread starter Thread starter jwilliam
  • Start date Start date
J

jwilliam

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?

This topic is pretty urgent, so a quick response is VERY much
appreciated.

thanks,
Jenise
 
Hello,

I'm not really in the position to buy a product at the moment. I'm
really looking into some direction on how I can produce this action
myself. I've already got the VBA code, I just need a way to trigger my
code to run automatically so I don't have to push the button myself
every morning.

thanks,
Jenise
 
I'm really looking for some direction on how I can automate it myself.
I'm not in the positon to purchase a product at the moment.

thanks,
Jenise
 
Hi Austin,

I can have the task scheduler point to the powerpoint presentation I've
created, but how do I get the vba code to automatically run after it
has been opened.

thanks,

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?
Click to expand...

If it were part of an addin with an Auto_Open subroutine, you could have your
code execute every time PPT starts up, then use the Windows Scheduler to start
PPT automatically.

You might also be able to use a VBScript (scheduled to run at a certain time
daily) to invoke PPT, load a specific file and launch a macro in it, or perhaps
convert your VBA code to VBScript code to accomplish the same thing.

I don't know much about VBScript, though.
 
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 presentation
and not for every presentation I work with. I also only want it to run
once. Once my macro runs and saves the presentations on the drive, I
open those saved files and the macro re-runs itself again.

Has anyone else had this issue and how did they resolve it?

thanks,

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 presentation
and not for every presentation I work with.
Click to expand...

An Auto_Open subroutine in an addin will run ONLY when the addin loads (ie, either
at PPT startup or when you manually load the addin yourself).
 
Back
Top