How to save EXCEL file at specified datetime, say at midnight 00:0
 

I have one application need to automatically save EXCEL master file into new
file at everyday midnight 00:00:00AM,

how to trigger this midnight event from excel workbook?

How to save EXCEL file at specified datetime, say at midnight 00:0
 

Kelvin;

Check the Application.OnTime method

--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands (Those who live some 18 feet below sea level)
--
E:
W: www.spreadsheetsolutions.nl
--

"kelvin" wrote in message
...
I have one application need to automatically save EXCEL master file into
new
file at everyday midnight 00:00:00AM,

how to trigger this midnight event from excel workbook?