auto open

[kemperohlmeyer]

Does anyone know the VBA code to tell an excel workbook to automatically open, update, execute a macro, save and close on a regular schedule?

Thanks,
Kemper

 

[MDuff]

this may help thanks to Chip Pearson's Scheduling Procedures With OnTime

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

 

[kemperohlmeyer]

thanks!