Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Feb 2001
    Location
    Toronto, Ontario, Canada
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Specify Excel Version in Task Scheduler (Excel 2000/2003)

    Task supposed to run daily refuses to run now that Excel 2003 has been installed.
    Versions of Excel in different locations running fine otherwise.
    .cmd file simply opens an Excel file which runs code in its Open Event.
    .cmd file executes flawlessly when typed into the Start/Run box.
    Macro security set to Low.
    Does anyone have any ideas?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Specify Excel Version in Task Scheduler (Excel 2000/2003)

    I don't complete understand what is not working.

    From what I understand, the scheduler opens excel and an excel file and the file runs its workbook open code. What else do you want to happen?

    Steve

  3. #3
    Lounger
    Join Date
    Feb 2001
    Location
    Toronto, Ontario, Canada
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Specify Excel Version in Task Scheduler (Excel 2000/2003)

    Steve,
    The scheduler was opening the file but no longer does.
    Ross

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Specify Excel Version in Task Scheduler (Excel 2000/2003)

    In the scheduler, insert the complete path to the Excel version you need, followed by the path and filename of the file to open, e.g.:

    "crogram filesmicrosoft office 2003office11excel.exe" "c:databook1.xls"
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Lounger
    Join Date
    Feb 2001
    Location
    Toronto, Ontario, Canada
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Specify Excel Version in Task Scheduler (Excel 2000/2003)

    Jan Karel,
    Adding the path to the program seemed like the answer, and I am pleased to now know how to programmatically choose the version of Excel I'd like to run, but it still refuses to run from the scheduler. Ok in the Run box, but when I right-click on the item in the scheduler it just stares back at me
    Ross

  6. #6
    Lounger
    Join Date
    Feb 2001
    Location
    Toronto, Ontario, Canada
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Specify Excel Version in Task Scheduler (Excel 2000/2003)

    To all those who puzzled over this post: The task scheduler is a neat tool, but when day after day it does what you want without fail, you might forget about it. I did, until one day I decided to check and saw that it had not performed for OVER A MONTH. Luckily, the task was not critical, but what if it had been? I thought it went off the rails because at about that time (yes, a log of changes would have nailed the time!) I installed an extra version of Excel. What I forgot was that I had changed my password. How did I find out? By looking (finally) at the scheduler's log, silly. There are several lessons here for me, maybe for others too.

  7. #7
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Specify Excel Version in Task Scheduler (Excel

    >you might forget about it

    Given that it takes a minimum of 4 clicks to access any Task - unless you build the entire Tasks folder into QuickLaunch - forgetting about it is tempting. <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>
    Gre

Posting Permissions

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