Run Macro w/o Opening Excel
 

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!


---
Message posted from http://www.ExcelForum.com/

Run Macro w/o Opening Excel
 

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..

--
Message posted from http://www.ExcelForum.com

Run Macro w/o Opening Excel
 

I can't use task manger, corparate blockou

--
Message posted from http://www.ExcelForum.com

Run Macro w/o Opening Excel
 

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...??

--
Message posted from http://www.ExcelForum.com

Run Macro w/o Opening Excel
 

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

--
Message posted from http://www.ExcelForum.com

Run Macro w/o Opening Excel
 

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

--
Message posted from http://www.ExcelForum.com

Run Macro w/o Opening Excel
 

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

--
Message posted from http://www.ExcelForum.com

Run Macro w/o Opening Excel
 

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

--
Message posted from http://www.ExcelForum.com