You may want to setup a automatic service that performs the task. From
a command line open a workbook which as Worbook Open Event that
automatically runs the macro at night. See Excel Command Line options

http://office.microsoft.com/en-us/ex...580301033.aspx


Put the command line into a batch file (*.bat) which can be call from a
service on a PC.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=153064

Microsoft Office Help