Auto open

[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

 

[Jim Rech]

I'd consider using the Windows Scheduled Tasks applet.

 

[Gord Dibben]

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

 

[Jim Rech]

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.

 

[Gord Dibben]

Thanks Jim


It is rather ambiguous, but I knew what I meant<g>

Gord