Macro

  • Thread starter Thread starter Guest
  • Start date Start date
Sophie

Yes, it is possible using the OnTime method.

See Chip Pearson's site.

http://www.cpearson.com/excel/ontime.htm

You can open the file from another workbook that is running and has the OnTime
code in it.

An alternative if Excel is not running is to start Excel with your particular
file. You could use Windows Task Scheduler and a startup switch in the
shortcut to Excel to do that.

Gord Dibben Excel MVP
 
Back
Top