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
Occasional Contributor

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

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

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

Occasional Contributor

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

Get properties of a web page element

See replies!

Compare images using the Region Checkpoint

See replies!

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

Participate!

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

Participate!
Top Kudoed Authors