Save and close a Workbook at 5:00 PM?

christophermartin

New Member
Joined
Jul 28, 2015
Messages
21
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.
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Jaafar Tribak

Well-known Member
Joined
Dec 5, 2002
Messages
7,929
Office Version
  1. 2016
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,620
Messages
5,523,944
Members
409,543
Latest member
LaMaqu1na

This Week's Hot Topics

Top