automating macro

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

Chris, have a look at Chip's site here
http://www.cpearson.com/excel/ontime.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"chris" <[email protected]> wrote in message
news:[email protected]...
> 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

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" <[email protected]> wrote in message
news:[email protected]...
> 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