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:

Dim objXCL
Dim XCLpath
Dim XCLname
Dim XCLfullname

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''

Else
MsgBox ''Excel file is not open'', vbInformation,''Excel Status''

End If