Auto savel Excel file at specified time
 

Hi, Excel Guru:
how to trigger the excel to save master workbook file at specified time, say
everyday midnight, with the datetimestamp at excel file name
1 no need open the saved new file
2 Master file will not allowed to closed due to pulling data though DDE link

thanks

Auto savel Excel file at specified time
 

Is the master file always going to be open?, if its recieving data how
is the workbook/worksheet refreshed to show that data? do you have
OnTime code in your workbook?

kelvin;213343 Wrote:
Hi, Excel Guru:
how to trigger the excel to save master workbook file at specified
time, say
everyday midnight, with the datetimestamp at excel file name
1 no need open the saved new file
2 Master file will not allowed to closed due to pulling data though
DDE link

thanks


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58549