Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a number of Scheduled Tasks that stopped working. Viewing the log file (Advance>View Log File), I find references to an "invalid path". The Scheduled Tasks open Excel files which run some code. Other than this, not much to it.

    I'm not sure why the invalid path reference is coming up. I have used the "browse" button to select the file but still get the error.

    Thanks for your advice,
    John

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    20,418
    Thanks
    1
    Thanked 597 Times in 534 Posts
    [quote name='jstevens' post='791924' date='02-Sep-2009 23:00']I have a number of Scheduled Tasks that stopped working. Viewing the log file (Advance>View Log File), I find references to an "invalid path". The Scheduled Tasks open Excel files which run some code. Other than this, not much to it.

    I'm not sure why the invalid path reference is coming up. I have used the "browse" button to select the file but still get the error.[/quote]

    "Browse" button in what product?

    Can you find the file(s) with Windows Explorer? Were any access permissions changed on the folder or files that are being used? Was the account for the scheduled task changed?

    Joe

  4. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I found the issue with the Scheduled Tasks failing. It is related to the drive mapping where the Schedule Task envokes Excel to open Excel files. There is a generic service account that runs the Scheduled Tasks when Users are logged off the server.

    The task points to an Excel file in a mapped drive. To keep this post short, the drive letter was swapped out with the UNC of the server and all things are good.

    Regards,
    John

  5. #4
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    20,418
    Thanks
    1
    Thanked 597 Times in 534 Posts
    [quote name='jstevens' post='792886' date='10-Sep-2009 15:03']I found the issue with the Scheduled Tasks failing. It is related to the drive mapping where the Schedule Task envokes Excel to open Excel files. There is a generic service account that runs the Scheduled Tasks when Users are logged off the server.

    The task points to an Excel file in a mapped drive. To keep this post short, the drive letter was swapped out with the UNC of the server and all things are good.

    Regards,
    John[/quote]

    Good news. Thanks for posting back.

    Joe

Posting Permissions

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