Auto opening excel

[c19h28O2]

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

[Jacob Hilderbrand]

You can just leave Excel open all night and set up some code to run. Something like this:


Option Explicit

Private Sub Workbook_Open()

Application.OnTime TimeValue("00:00:00"), "Macro1"

End Sub


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.

[smc2911]

Presumably you don't have access to scheduler in that locked down state?

[c19h28O2]

Hi,

Afraid not, infact i don't even have access to the C:\ drive!

Thanks

C19