| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run Macro w/o Opening Excel
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening a Macro in Excel 2007 | Excel Discussion (Misc queries) | |||
| Opening an Excel file with macro | Excel Discussion (Misc queries) | |||
| Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming | |||
| Opening Word Ducuments From Excel Macro | Excel Programming | |||
| Opening a webpage from a vba macro in excel | Excel Programming | |||
Hybrid Mode
