Hi,What options do I have to use excel as a "Service" i.e. run every night at 12am? the version of xp i am using is a work version and is locked down very tightly. what i mean by tightly is that i cannot even view the clock properties!!!!!Thanks
Hi,What options do I have to use excel as a "Service" i.e. run every night at 12am? the version of xp i am using is a work version and is locked down very tightly. what i mean by tightly is that i cannot even view the clock properties!!!!!Thanks
You can just leave Excel open all night and set up some code to run. Something like this:
[vba]
Option Explicit
Private Sub Workbook_Open()
Application.OnTime TimeValue("00:00:00"), "Macro1"
End Sub
[/vba]
When you open the workbook (This could be a specific workbook or personnal.xls) this code will run and tell Excel to run the macro "Macro1" at midnight.
Presumably you don't have access to scheduler in that locked down state?
Hi,
Afraid not, infact i don't even have access to the C:\ drive!
Thanks
C19