Forum Discussion

Ivett_K's avatar
Ivett_K
Occasional Contributor
4 years ago
Solved

Comparing Excel files - Can't find file

Hi Everyone,

 

I've been trying to run the script for comparing the Excel files, but I get the following error when I try to run it:

 

'Sorry, we couldn't find \tilney.dev\\dfs\\user_data\\Kaufman_Dev\\Desktop\\mytilney_t.xlsx. Is it possible it was moved,renamed or deleted?

 

Microsoft Excel

script.vbs Line: 11 Column: 2.

 

Plug-in: Excelfiles checkpoint 1.3 by Smartbear Corp.

Location: c:\Program Files (x86)\SmartBear\TestComplete 14\Bin\Extensions\ScriptExtensions'

 

Please also see screencapture attached.

 

The script is as follows:

 

function Main()
{
xlfile1 = "\\tilney.dev\\dfs\\user_data\\Kaufman_Dev\\Desktop\\mytilney_t.xlsx";
xlfile2 = "‪\\tilney.dev\\dfs\\user_data\\Kaufman_Dev\\Desktop\\plan_t.xlsx";
resfile = "‪\\tilney.dev\\dfs\\user_data\\Kaufman_Dev\\Desktop\\result.xlsx";
Log.Message(objectExcel.ExcelCompare(xlfile1,xlfile2,resfile));
}

 

The file paths and names are correct I believe - any ideas why the file cannot be found?

 

Many thanks,

 

Ivett

 

 

 

 

 

 

 

  • Hi Marsha,

     

    I solved the problem by saving the files in a different location.

     

    Thank you for your help.

     

    Ivett

3 Replies

  • Marsha_R's avatar
    Marsha_R
    Champion Level 3

    I'm not sure of your syntax, but if tilney.dev is your server name is it going to need two slashes in front of it to have a correct path?  Try typing four slashes in front of it and see what happens.

    • Ivett_K's avatar
      Ivett_K
      Occasional Contributor

      Hi Marsha,

       

      Thank you for your reply.

       

      I changed the forward slashes to 4 in front of tilney.dev, but I'm still getting the same error message.

       

      Best regards,

       

      Ivett

      • Ivett_K's avatar
        Ivett_K
        Occasional Contributor

        Hi Marsha,

         

        I solved the problem by saving the files in a different location.

         

        Thank you for your help.

         

        Ivett