View Full Version : Auto opening excel
c19h28O2
03-06-2006, 08:43 AM
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
03-06-2006, 08:56 AM
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
03-10-2006, 02:33 AM
Presumably you don't have access to scheduler in that locked down state?
c19h28O2
03-10-2006, 02:52 AM
Hi,
Afraid not, infact i don't even have access to the C:\ drive!
Thanks
C19
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.