I have a spreadsheet that reads data from an SQL
database, manipulates it, and passes it back to a
Sharepoint list. I have developed a macro that does the
data manipulation and synchronization with Sharepoint.

I'd like to define a scheduled task that launches the
file. On file open, I want the macro to launch after the
external links have been refreshed and once the macro is
complete I want to quit and save the file.

I'm new to VB, so any help you can provide to point me in
the right direction would be greatly appreciated. Thanks
in advance.