| 0 |
Subject: Setting up a macro to run overnight
Posted by: Guru
- [330592710] Sun, Apr 17, 2005, 19:21
Suppose I have an Excel macro that I would like to run at 6:00am every day. The Macro could be set up to run automatically when the spreadsheet is loaded, so perhaps what I really need is software that would open a specified spreadsheet at a predetermined time.
What's the best way to do this? Is anything built into Windows XP (Pro) to do this, or do I need some extra software? |
| 1 | Astade
ID: 473401011
Sun, Apr 17, 2005, 20:06
|
Guru,
I'm pretty sure you could buy software to run this on a daily basis.
If you want a quick fix (read: hack) here's how I would do it -
Open Excel and go to Tools->Options->General
Change your default file location to point to the file where the macro is.
Then go to Start->Programs->Accessories->System Tools -> Scheduled Tasks. This is the Windows Task Scheduler. You can create a profile to open up excel at 6am on a daily basis.
Hope this helps until you find a permanent solutions.
|
| 2 | RecycledSpinalFluid
Dude
ID: 204401122
Sun, Apr 17, 2005, 20:11
|
Scheduled Tasks:
Start - Accessories - System Tools - Scheduled Tasks
|
| 3 | Astade
ID: 473401011
Sun, Apr 17, 2005, 20:13
|
Sorry I mixed it up, in Excel you would need to change either the default startup directory or add your excel file (w/ macro) to your XLStart directory.
To change the default startup directory you can change the path by going to Tools->Options->General as well
|
| 4 | RecycledSpinalFluid
Dude
ID: 204401122
Sun, Apr 17, 2005, 20:15
|
Oops...I'm a little slow to hit "post"... :)
|
| 5 | RecycledSpinalFluid
Dude
ID: 204401122
Sun, Apr 17, 2005, 20:15
|
Oops...I'm a little slow to hit "post"... :)
|
| 6 | RecycledSpinalFluid
Dude
ID: 204401122
Sun, Apr 17, 2005, 20:16
|
Apparently not slow enough to double post...
|
| 7 | Guru
ID: 330592710
Sun, Apr 17, 2005, 20:45
|
The spreadsheet includes links to external spreadsheets, which I do not want to update when it runs. When the sheet loads, Excel always prompts for a Yes/No as to whether I want to update the workbook with changes to the external workbooks.
Can I set this up so that when the sheet loads, it automatically skips past this need for a response?
Or should I just redesign the spreadsheet to eliminate external links?
|
| 8 | Dr. Doom
ID: 430271612
Sun, Apr 17, 2005, 21:09
|
In Excel you should be able to go into the Tools -> Options -> Edit menu and there should be a checkbox that will suppress that prompt.
Regarding the automated running of Excel, I am sure there are many different freeware products or at least moderately priced ones that will suffice. I have one that I have used for many years, and it works very nice, at least for me, however this was not one of the free ones.
|
| 9 | Astade
ID: 473401011
Sun, Apr 17, 2005, 21:10
|
In Excel,
Tools-->Options-->Edit
Uncheck 'Ask to update Automatic links'
|
|
|
|
Post a reply to this message: (But first, how about checking out this sponsor?)
|