You could access the information about the new Excel file using the GetObject and then a few properties. Store them in variables to use later in your script or whatever you are trying to do in the test. The code below will get you the path, name, and full name of the Excel Sheet that is opened from your application:
OnError Resume Next
Set objXCL = GetObject(,''Excel.Application'')
If Not TypeName(objXCL) =''Empty'' Then
XCLpath = objXCL.Workbooks(1).path, vbInformation, ''Excel Status''
XCLname = objXCL.Workbooks(1).name, vbInformation, ''Excel Status''
XCLfullname = objXCL.Workbooks(1).fullname, vbInformation, ''Excel Status''
MsgBox ''Excel file is not open'', vbInformation,''Excel Status''