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

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.