thanks for your help.

now, I have the following codes written:


Sub Archive()

Application.OnTime TimeValue("12:02:00"), "Grab_data", schedule = True

End Sub

It looks like i will have to run this macro everytime when i open the
spreadsheet in order to make it work. is that true? Is there anyway
to get around this? I am not the only user to use the spreadsheet, I
am just worried that other user may forget to run this when they open
the spreadsheet.

Again, thanks for the help

regards,
chuck


--
chucklee
------------------------------------------------------------------------
chucklee's Profile: http://www.excelforum.com/member.php...o&userid=29071
View this thread: http://www.excelforum.com/showthread...hreadid=487968