Forum Discussion
If not DDT then ADO might work better.
https://support.smartbear.com/testcomplete/docs/reference/program-objects/ado/index.html
Personally, I would not choose to open Excel just to read values from it. DDT has capacities that would allow that, and if sufficient, ADO works great.
hi,
my Excel-closing routine works as follows:
While Excel Process exists
get visible "XLMAIN" Windows
If #XLMAIN > 0 Then
Set ExcelApp = Xlmainwindow.Window("XLDESK").Window("EXCEL7").NativeObject.Application.Application
For Ix = ExcelApp.Workbooks.Count To 1 Step -1
' close Workbooks without saving
If ExcelApp.Workbooks(Ix).Windows(1).Visible Then ExcelApp.Workbooks(Ix).Close False
Next
ExcelApp.Quit
Set ExcelApp = Nothing
End IF
End While
Related Content
- 7 years agotechgirlbb
Recent Discussions
- 8 hours agoSvetaG