Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Problem with using Task Scheduler to open Excel file


14 Nov 2013   #1

Windows 7 Professional 32-bit
 
 
Problem with using Task Scheduler to open Excel file

Hello,

I want to use the Task Scheduler to open an Excel file. The Excel file contains a macro that automatically runs when the file is opened. At the end of the routine the macro saves the file and closes the Excel application using the following commands:
>ThisWorkbook.Save
>Application.Quit

When I open this excel file in a normal way, such as double-clicking on the file, the macro runs successfully and Excel closes. However, when I use the Task Scheduler to open the excel file, the Excel Application does not close when the routine is finished.

Note that Iíve tried using the Task Scheduler to open this Excel file on other computers that are running the 64 bit version of Windows 7 and it works flawlessly. Iím only having this issue on a computer that is running the 32 bit version. Any ideas?

My System SpecsSystem Spec
.

Reply

 Problem with using Task Scheduler to open Excel file




Thread Tools



Similar help and support threads for2: Problem with using Task Scheduler to open Excel file
Thread Forum
Task Scheduler - Win 7 64-bit - problem running .bat file "Hello..." General Discussion
When I open Windows 7 Task Scheduler this is the errors that I get. General Discussion
Windows Task Scheduler stays active after it runned a batch file Performance & Maintenance
When I open the Task Scheduler, I get an error message... General Discussion
Task Scheduler problem General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 01:50 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33