| || |
Closing WB before sheets
UFT 12.01 or any UFT or QTP.
What happens if I'm using the ADO to communicate with Excel.
I create the Excel Application book, sheet objects.
I set the sheet object to a sheet.
Now everything is connected
Book object is set to Nothing before setting the sheet to nothing.
Does the sheet stay alive?
Of course I can experiment, but I thought it is an interesting question for discussion.
Nothing to do with QTP. Good discussion for a MS Office forum
With an ADO connection you don't really create a workbook or sheet object, just the connection and recordset. Moving between sheets is a matter of the correct query. SELECT * FROM [Sheet1$]
Yes you are right. Sorry I should have put this in a different forum or area of SQA forums. I just put another question about Excel VBA on this site in a more relevant forum. If I don't get an answer, I will try Mr. Excel site.
I just feel at home here.