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