Hi
I would not use Excel/VBA for this as this would require a running
Excel application. Try searching for a scheduling program on operating
system level (there're a lot of shareware schedulers available)

--
Regards
Frank Kabel
Frankfurt, Germany


We have a file that is updated constantly and would like to start
tracking the changes. I could make a macro that would easily save a
copy everytime the file is edited by a user, but that would create a
lot of files! Is there any way i could have the workbook saved to a
particular location every day at midnight?

It would be saved as "myWB" & Date & ".xls" to keep the files
uniquely
named.


---
Message posted from http://www.ExcelForum.com/