Comparing Excel files - Can't find file

[Ivett_K]

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

[Marsha_R]

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]

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 · Accepted solution]

Hi Marsha,

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

Thank you for your help.

Ivett