I am creating a spreadsheet using code like this:
* start Excel
Set_Ref Com(#ExcelApp) To(*CREATE_AS #VV_EXCEL.Application)
* Create worksheet
#ExcelApp.Workbooks.Add Template(-4167) Add_Retval(#ExcelWorkbook)
Set_Ref Com(#ExcelWorksheet) To(*Dynamic #ExcelApp.ActiveSheet)
I have routines to set Excel to *Null, but the user is closing the spreadsheet using the "X". That leaves my Excel reference open. Is there an event I can use know they closed it?
How can I check if excel is open and active?
This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
1 post • Page 1 of 1