Excel Activex in VL-WIN Check if open

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.
Post Reply
atostaine
Posts: 696
Joined: Wed Jan 20, 2016 7:38 am

Excel Activex in VL-WIN Check if open

Post by atostaine »

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?
Art Tostaine
Top
Post Reply

Return to “Questions & Answers”