Forum Discussion

nounge's avatar
nounge
Occasional Contributor
8 years ago

TestComplete12: Excel sheet not found error when executing as batch

On TestComplete 9, I was using the Windows Task Scheduler to run a suite of (scripted) tests by command line execution every day. I also use Excel to parameterize input for the tests. This had been w...
  • tristaanogre's avatar
    tristaanogre
    8 years ago

    I'm still thinking it's a permissions thing in some way...  Running it at the "Run" prompt in windows is running it using your user account.  Running it as a task in task scheduler or as a batch, potentially, may be using a different user account or privilege level or, if it's running as you, it MIGHT not be running with the most elevated privileges you have (admin).

     

    Try in your task setting the security options to have it run as an administrator. I know it seems strange, but give it a shot and see if that works.

nounge's avatar
nounge
Occasional Contributor

Here is the error message.

I've looked into the 3 suggested problems but none seem likely in the slightest.

tristaanogre's avatar
tristaanogre
Esteemed Contributor
8 years ago

I'm still thinking it's a permissions thing in some way...  Running it at the "Run" prompt in windows is running it using your user account.  Running it as a task in task scheduler or as a batch, potentially, may be using a different user account or privilege level or, if it's running as you, it MIGHT not be running with the most elevated privileges you have (admin).

 

Try in your task setting the security options to have it run as an administrator. I know it seems strange, but give it a shot and see if that works.

  • nounge's avatar
    nounge
    Occasional Contributor
    8 years ago

    The problem has been fixed. Sorry for not responding, I did not work between last Thursday and today.

     

    You were probably right about the permissions issue. The Task Scheduler selection "Run whether user is logged on or not" was causing the problem. This may have changed permission before accessing the spreadsheet. Not sure exactly why batch wasn't working still, but that was primarily to help debug the problem.

     

    Thank you for your help.

     

    Merry Christmas! Kudos!