release Excel from memory in Visual Cobol

Hi all,

Many thanks for all the useful posts over the last while which let me pick up some great hints and tips.

We ported our application from Net Express to Visual Cobol and made various changes to some programs that interface with Excel. I have been unable to figure out how to release Excel from memory in the Visual Cobol code though and would be very grateful if anyone can help.

The earlier Net Express code let me release Excel by cycling through the used objects with invoke Worksheet "finalize" returning Worksheet and so on, but I am not sure what the equivalent is in Visual Cobol.

Many thanks,

John 

Parents
  • Hi Chris,

    Many thanks for getting back to me.

    Yes, we did change everything to use the MS-Office Interop classes.

    I looked at a few VB and C# forums to try work out how to replicate things like "Marshal" or "GC (Garbage Collection)" in the Visual Cobol code but am a bit baffled at the moment. If it proves to be a few hoops to jump through then I'll look at going back to the COM support in the native code project.

    John

Reply
  • Hi Chris,

    Many thanks for getting back to me.

    Yes, we did change everything to use the MS-Office Interop classes.

    I looked at a few VB and C# forums to try work out how to replicate things like "Marshal" or "GC (Garbage Collection)" in the Visual Cobol code but am a bit baffled at the moment. If it proves to be a few hoops to jump through then I'll look at going back to the COM support in the native code project.

    John

Children
No Data