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
