Save and close a Workbook at 5:00 PM?

[christophermartin]

Hi,
I'm still very new to VB.
I would like to save and close a Workbook that collects data off the stock exchange. Exactly at 5:00 PM (Eastern).
Also, where would the code reside (regarding modules)?
Thanks for your attention.
Chris.

 

[Jaafar Tribak]

Hi,
I'm still very new to VB.
I would like to save and close a Workbook that collects data off the stock exchange. Exactly at 5:00 PM (Eastern).
Also, where would the code reside (regarding modules)?
Thanks for your attention.
Chris.

Take a look at the Application.OnTime Method to schedule a Macro... there are plenty of examples in the forum.

 

[christophermartin]

Thanks, I'll try it.
Chris