Auto open

  • Thread starter Thread starter jeffO
  • Start date Start date
J

jeffO

I am looking for a method to open and update an excel file. I want this
to happen at the same time each day. I know how to write the code once
the file is open, but don't know how to get the file to auto open. Any
help would be greatly appreciated.
Jeff
 
Jeff

Windows Task Sdheculer to start Excel and open the file with the update code
in a Workbook_Open sub in the Thisworkbook module.

There are third-party apps out there that work better than Task Scheduler.

OR, if Excel is always running you could have an OnTime macro in your
Personal.xls that could open your file, do the update, then close it.

Gord Dibben XL2002
 
Windows Task Scheduler to start Excel and open the file

Just so there is no confusion, use Task Scheduler to open the XLS. Just
like double-clicking Windows knows what app to open.
 
Back
Top