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,

    Thanks again for that info ... I will give it a try later today.

    I didn't used the word "type" between the "Invoke" and "Marshal" which is probably why I was getting  verb/operand unrecognised errors.

    I'll let you know how I get on with using the code you provided.

    John

Reply
  • Hi Chris,

    Thanks again for that info ... I will give it a try later today.

    I didn't used the word "type" between the "Invoke" and "Marshal" which is probably why I was getting  verb/operand unrecognised errors.

    I'll let you know how I get on with using the code you provided.

    John

Children
No Data