+ Reply to Thread
Results 1 to 6 of 6

Running Excel from task scheduler. Scheduler doesn't end

  1. #1
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Running Excel from task scheduler. Scheduler doesn't end

    I am using the standard Windows task scheduler to open an excel file and on quitting the application the scheduler still shows the task as "running".
    I have simplified the code right down and continue to get the problem.

    Please Login or Register  to view this content.
    Any ideas? (and the go.txt file does exist)


    click on the * Add Reputation if this was useful or entertaining.

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Running Excel from task scheduler. Scheduler doesn't end

    I guess this is a "no ideas"

  3. #3
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Running Excel from task scheduler. Scheduler doesn't end

    does the file actually close?
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  4. #4
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Running Excel from task scheduler. Scheduler doesn't end

    Yes.
    In the scheduler I have a task which has the action : start a program which is wrapper.xlsm
    I click on Run and Excel starts up (at which point EXCEL.EXE shows up in Windows Task Manager).
    It runs through to the Application.Quit and closes EXEL.EXE now disappears from Windows Task Manager (which seems to suggest it has fully closed.
    But in the Task Scheduler the task still shows as Running. (Which is the problem. Why hasn't it ended?)

  5. #5
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Running Excel from task scheduler. Scheduler doesn't end

    I have seen weird things happen when people do this....

    In the run section of the scheduler they put this: c:\<whereever MicroSoft put office>\EXCEL.exe "C:\<whereever you put your file>\YourFileName.xlsm"

    instead of:
    "C:\<whereever you put your file\YourFileName.xlsm"

    so for me, I just have this in the run box.

    "O:\Inventory Analyst\0-Special_Projects\Automation\634-ActiveDemandSummary.xlsm"

    just a thought

  6. #6
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Running Excel from task scheduler. Scheduler doesn't end

    Thanks for the input
    What I have is quite simple

    C:\exceltest\test.xlsm

    so I think I have a different problem

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Task Scheduler Stopped Working - Excel
    By profector in forum Microsoft Windows Help
    Replies: 2
    Last Post: 01-28-2014, 11:11 AM
  2. Run Excel and macro using Windows Task Scheduler
    By MilroyD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2013, 11:24 PM
  3. [SOLVED] Use Task Scheduler to automatically run Excel workbook
    By John Hazel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2006, 09:10 AM
  4. Replies: 2
    Last Post: 03-18-2006, 10:50 AM
  5. [SOLVED] Detect Excel was started with Windows Task Scheduler
    By RB Smissaert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-01-2005, 08:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1