Run a macro automatically at a certain time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What I am trying to do is have a macro run at a certain time and save it
automatically. I have the save portion figured out but I can't seam to get
it to run at a certain time. Any help would be greatly appreciated.
 
I generally make it an Auto_Open macro (to execute whenever the file is
opened), then set the Excel file to run as a Windows Scheduled Task.
 
Start > Control Panel > Scheduled Tasks. Click Add Scheduled Task. Click
Next, then choose your Excel workbook. Select the frequency and the time.
Enter your password (note that you'll have to maintain this as your logon
password changes). Click Next, select 'open advanced properties...' and
click Finish.
To allow this to run unattended, you've also got to avoid the security
warning. The preferred way to do this is to leave your macro security at
medium (tools > macros > security), sign your macro (use selfcert.exe and
select your certificate from the VB Editor, tools > digital signature...) and
choose to trust yourself when you next open the macro file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
Automatic Date and Times 2
Run Macro If Cell have "x" value 0
CF, MACRO??? 3
automatically trying to run a macro at a certain time 0
automatically trying to run a macro at a certain time 1
Automatic update of footer macro 2
Help with a Macro 2

Back
Top