Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
rodlee Absent Member.
Absent Member.
1219 views

Excel Not clearing from memory

We have an issue with the Excel.exe not clearing from the list of processes, but only on 64bit systems (Windows 7 and Server 2008).    32bit is fine

CREATE @Application of @Excel handle in EX-APP

 MODIFY EX-APP @Workbooks::Open ( ws-ltout-file ,0,0) 

     giving EX-WORKBOOK.

MODIFY EX-WORKBOOK @PrintOut()       

call "c$sleep" using "2"

# next line added, but no change in behavior

MODIFY EX-APP @DisplayAlerts = 0

MODIFY EX-WORKBOOK @Close()

DESTROY EX-WORKBOOK

MODIFY EX-APP @Quit()

DESTROY EX-APP

I've seen the following online, but I'm not sure how to code this in Acu.

System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)

obj = Nothing

Thank you for any assistance!

 

 

 

Tags (2)
0 Likes
1 Reply
Micro Focus Expert
Micro Focus Expert

RE: Excel Not clearing from memory

You may want to contact Customer Care ... a fix for 9.2.0 ecn4182: : EXCEL.EXE fails to shut down when destroying the handle                            .. you may need to get a patch to whatever version you are using.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.