View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Curt D.
 
Posts: n/a
Default Run a macro automatically at a certain time

Can you make it auto open at a certain time for this to work?

"bpeltzer" wrote:

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.

"Curt D." wrote:

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.