tags:

views:

29

answers:

1
Q: 

How to load single COM instance for multiple application instance

Hi,

I'm creating a COM dll and it will be loaded by VBA. However, I noticed that for every excel instance (workbook), a new COM object is loading to memory. But I need to maintain single COM state irrespective of number of Excel instances exists.

Please help me achieve this purpose .

Thank you

A: 

Maybe this will help you:

Implementing the Singleton Pattern in C#

cevik  2010-06-29 13:46:29

related questions

Exposing nested arrays to COM from .NET
How do you unit-test code that interacts with and instantiates third-party COM objects?
Windows Server 2008: COM error: 0x800706F7 - The stub received bad data
Sample code for using IBM's PCOMM in C# o write an as400 screenscraper
Expose an event handler to VBScript users of my COM object
MapPoint 2009 Load Performance
Managed OleDB provider written in C#
What is the best source for information on COM error codes?
How do I return an array of strings from an ActiveX object to JScript
Maintain the correct version for a COM dll referenced in a .NET project
How to do a simple mail merge in OpenOffice
How do you display a dialog from a hidden window application?
Has .NET made raw COM and DCOM programming redundant ?
COMException "Library not registered." while using System.DirectoryServices
What do I need to do to implement an "out of proc" COM server in C#?
How to implement Type-safe COM enumerations in Delphi ?
Notification of drop in drag-drop in Windows
Sharepoint COMException 0x81020037
How do I unregister COM dlls initially added with RegSvr32 when the /u arg doesn't work?
Delphi and COM: TLB and maintenance issues
Is there a method for handling errors from COM objects in RDML?
How to register COM from VS Setup project?
C++ Problems with #import of .NET out-of-proc server.
How to trace COM objects exceptions?
Unload a COM control when working in VB6 IDE