Release object question

[Francois PIETTE [ICS - MidWare]]

Hello,

My Delphi application expose a few COM interfaces which are used from Excel
2007 VBA macros.
Everything works as expected except Delphi is unable to recreate the exe
file before the excel worksheet is closed.
I guess it is because Excel keep a reference to the exe file, maybe for the
type library.
In the VBA code, I call CreateObject, then I use the methods and properties
and the I assing "Nothing" to the object variable. Is there anything else I
can do to release the Delphi executable file ?

Thanks.

--
francoi...@overbyte.be
The author of the freeware multi-tier middleware MidWare
The author of the freeware Internet Component Suite (ICS)
http://www.overbyte.be

[Marc Rohloff [TeamB]]

On Sat, 26 Jul 2008 07:27:10 +0200, Francois PIETTE [ICS - MidWare]
wrote:

> In the VBA code, I call CreateObject, then I use the methods and properties
> and the I assing "Nothing" to the object variable. Is there anything else I
> can do to release the Delphi executable file ?

You could try calling the CoFreeUnusedLibraries windows API.

--
Marc Rohloff [TeamB]
marc -at- marc rohloff -dot- com

[Francois PIETTE [ICS - MidWare]]

>> In the VBA code, I call CreateObject, then I use the methods and
>> properties
>> and the I assing "Nothing" to the object variable. Is there anything else
>> I
>> can do to release the Delphi executable file ?
>
> You could try calling the CoFreeUnusedLibraries windows API.

Doesn't work. No error, simply does nothing.