Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
Open an Excel Workbook with Windows Scheduler
My Excel file has Auto_Open() ready to fire as soon as the workbook is opened. How can I open the file each morning at 6:00 A.M? Assuming the file is c:\users\bob\myfiles\x.xls
m, what exactly must I do to open that file with scheduler?
8/22/2022 - Mon
Here are the steps:
m Tools>Task Scheduler
Right-click Task Scheduler Library
Create Basic Task - go through the Wizard as follows
Enter a Name and Description for the task
Start time of 6:00am
Recurs every 1 days
Start a program
Click Browse and navigate to [c:\users\bob\myfiles\x.xl
That should do it! Regards, Joe
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today
7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
FYI, the batch file approach is not needed (it works, of course, but is not necessary). You may simply navigate directly to the Excel file and enter it in Task Scheduler, as I showed above. Regards, Joe
Joe, I tried it but couldn't get it to work for whatever reason.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
Hmmm, I don't understand that. I'm sure that Excel is associated with the file type [.xlsm]. I just went through the steps I posted and it worked perfectly. I'm very curious to understand why it didn't work for you. What happens if you follow my steps and then click "Run" in the Task Scheduler to run it immediately? Does it fail? If so, how? Thanks, Joe
The steps you posted are identical to social.technet.microsoft.c
9da8/ which is what I tried over the span of several hours before giving up and posting for help. In both the case of the batch and your solution I set the timer for about a minute in the future making sure that time had not yet occurred when submitted. The batch worked every time but I never got the other to even make a peep. xlsm is associated with Excel as double clicking the file does bring it up. I've no idea why but rather than digging through it all I just decided to ask for help.
I'm not familiar with the [social.technet.microsoft.
com] link that you posted. I simply went over the steps that I've used for all of my scheduled tasks and recorded the steps for you. I did it on a test xlsx (not xlsm, but it shouldn't matter since Excel owns xlsm) and it worked perfectly...as it does on all of my production scheduled tasks. I don't have a clue why it's not working for you...and I always like to understand why things don't work, but I guess this one will go down as one of life's mysteries. :)
Btw, it seems that the steps that are working for you are identical to the steps I posted, except that the target in mine is the xlsm file and the target in the other one is the batch file. This, of course, should not make a difference in terms of the Task Scheduler running it. Anyway, thanks for your responses...interesting stuff...I'm glad that the batch file approach is working for you. Regards, Joe
to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent