We haven't upgraded or applied the hotfix yet, but we have found what we think is a better approach than what we've been doing.

Rather than using ConnectToNewObject("Excel.Application"), we've tested the following:

result = myoleobject.ConnectToObject("","excel.application")

If result is 0, then an existing Excel.exe is already running, and we can use that. If it fails, returning something else, then we can startup Excel with a run() statement rather than by using ConnectToNewObject():

result = registryget("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\excel.exe", "Path", ls_excel_path)
result = run(ls_excel_path + 'EXCEL.EXE' )

If the run statement succeeds, we can retry the ConnectToObject() after Excel has been started.

This prevents the multiple orphan EXCEL.EXE processes we were seeing with the /automation -Embedding on the Command line when using myoleobject.ConnectToNewObject("Excel.Application")

Hi Jim,

When I execute the following code locally, the Excel process does not remain, it disappears automatically.

oleobject lole_excel
lole_excel = create oleobject
lole_excel.ConnectToNewObject("Excel.Application")
lole_excel.visible = TRUE
lole_excel.disconnectobject( )
destroy lole_excel
return

If you open an Excel file, execute Close() and then execute DisconnectObject(), then you can quit the Excel process. For example:

oleobject lole_excel,lo_ExcelSheet1,lo_ExcelSheet2
lole_excel = create oleobject
lole_excel.ConnectToNewObject("Excel.Application")
lo_ExcelSheet1 = lole_excel.WorkBooks.open('c:\1.xlsx')
lo_ExcelSheet2 = lole_excel.WorkBooks.open('c:\2.xlsx')
lole_excel.visible = TRUE
lo_ExcelSheet1.Close()
lo_ExcelSheet2.Close()
lole_excel.disconnectobject( )
destroy lole_excel
Return

Of course, you can also use Quit() directly to quit the Excel process. For example:

oleobject lole_excel,lo_ExcelSheet1,lo_ExcelSheet2
lole_excel = create oleobject
lole_excel.ConnectToNewObject("Excel.Application")
lo_ExcelSheet1 = lole_excel.WorkBooks.open('c:\1.xlsx')
lo_ExcelSheet2 = lole_excel.WorkBooks.open('c:\2.xlsx')
lole_excel.visible = TRUE
lole_excel.Application.Quit()
lole_excel.disconnectobject( )
destroy lole_excel
Return

For code rigor, I recommend that you use both Close() and Quit() before DisconnectObject

Regards,
Ken