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
|