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
Join TechCorner Challenge!
Want a fun and easy way to learn TestComplete? Try solving weekly TechCorner challenges and get into the Leaderboard!

Challenge Status

How to execute remote test and obtain results via Test Runner REST API

Participate!

Comparing content of HTML table with Excel file data

Participate!

Compare HTML table with Excel file and correct data in the file

Participate!

Retrieve Data from a Web Page

Participate!
Top Kudoed Authors