Run Macro w/o Opening Excel

C

cpinsent

I need to run a macro everyday, including the weekends but no one is
here to open the workbook or even excel. I can leave my computer on if
I need to, but I would rather not. I tried
Application.OnTime TimeValue("13:15:00"), "MyMacro" to run at a certain
time each day, but it still didn't work. Please Help!
 
E

E_R

Do you have access to the Windows Task Scheduler?

If so, schedule a batch job to shell out to your Excel file and put
call to your code in the Workbook_Open event.

Just a thought..
 
E

E_R

What about using the At command to schedule the task through MS-DOS?

I can't remember if the DOS scheduler is related to the Windows Tas
Scheduler...??
 
E

E_R

Whoa... Ijust noticed you said task MANGER - not SCHEDULER... jus
making sure we're on the same page
 
C

cpinsent

we're on the same page, i meant Task Scheduler. I basically can't mes
with any of the computer setting because I don't have administrativ
rights on my computer, so Dos commands won't work either. thanks fo
the input though
 
E

E_R

Well if you can stay logged on, and you can leave the book open, yo
could use the timer function to run the code. Though this is probabl
the worst way to do it.

Or maybe you could get an admin to schedule it for you
 
C

cpinsent

ok, i was able to get the admin password so i can go in a schedul
windows to open excel, but how do i open my file (which is all i reall
need to do, the code is set up to run when you open the file
 
Top