LinkBack URL
About LinkBacks
JapanDave 
How do you setup Windows Task Scheduler to run a macro every day at a certain time on windows home server 2011?
How do you setup Windows Task Scheduler to run a macro every day at a certain time on windows home server 2011?
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
what I have done in the past is use the scheduler to launch the excel file and then use the sub Auto_Open()....then call the macro you want to run....this seems to work for me....HTH
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Yeah, that is what I was going to do, but I have no idea how to setup the scheduler.
this goes in the run box of the scheduler window....setup your time and then put in the full path (not the mapped path) and the file name...that's all I do....
"\\Fully Qualified domain path\COMPARE^Ver3.xls"
Thanks for this.
Glad I could help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks