Near the end of my UFT code I want to open an Excel File and leave it open after UFT has finished running.
If I use the
xlApp, xlWb, xlSheet style of code I would expect the workbook to close when the objects are destroyed when UFT completes. I don't know if this assumption is correct.
Another way is to use:
but this shows the Excel Sheet with plus signs for expansion on the left side. Also some of the colors on the text are gone.
How does one leave an Excel WB open?
When in Florida, Don't Tampa with the code. I made this up.
Unfortunately the excel doesnt get closed if you just destroy the excel object - only workbook object.close will close the excel.
If you dont do this, you will still see that the excel is open after your execution.
Set ExcelObject = CreateObject("excel.application")
ExcelObject.visible = True
set wb = ExcelObject.Workbooks.Open("C:\Users\vgampvi\Deskt op\temp\excel1.xls",Default, False)