View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default automating macro

I would suggest using the OS scheduler to start Excel with a designated
workbook that has your code as workbook_open event code.

Put in good error handling though, or you may find the job suspended,
waiting for a response by someone who is not there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chris" wrote in message
...
Hello.

I have a macro in an Excel workbook that needs to run at 4am each morning.
Does anyone know where I can find an example of how that can be automated?

Any suggestions are appreciated, thank you!

Chris