cancel
Showing results for 
Search instead for 
Did you mean: 

Comparing Excel files - Can't find file

SOLVED
Highlighted
Occasional Contributor

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

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Occasional Contributor

Re: Comparing Excel files - Can't find file

Hi Marsha,

 

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

 

Thank you for your help.

 

Ivett

View solution in original post

3 REPLIES 3
Highlighted
Community Hero

Re: Comparing Excel files - Can't find file

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.

Highlighted
Occasional Contributor

Re: Comparing Excel files - Can't find file

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

Highlighted
Occasional Contributor

Re: Comparing Excel files - Can't find file

Hi Marsha,

 

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

 

Thank you for your help.

 

Ivett

View solution in original post

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors