How to share com component between C# and VBA

[Sridhar Yada]

Hi All,

Have a C# app which makes a call to VBA macro using in-memory excel.

I am unable to share the data between C# and VBA macro by using the same COM component.

Both C# and VBA invoked this COM component through interop layer.

Please advise.



Submitted via EggHeadCafe - Software Developer Portal of Choice
Using SQL Server Notification Services Platform
http://www.eggheadcafe.com/tutorial...0-4aae5e12f872/using-sql-server-notifica.aspx

 

[Gregory A. Beamer]

Sridhar Yada wrote in

Have a C# app which makes a call to VBA macro using in-memory excel.

I am unable to share the data between C# and VBA macro by using the
same COM component.

Both C# and VBA invoked this COM component through interop layer.

Using the same COM component? What do you mean?

If you mean, both can call the same component, then it is normal you cannot
share, unless the component persists the state, as each one is opening the
COM component in their own process space.

To put this in an analogy, it would be like stating, I just called
Microsoft and a guy in France has called Microsoft, why am I not privy to
his phone call?

Peace and Grace,

--
Gregory A. Beamer (MVP)

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************

 

[Wilson, Phil]

You might mean that an COM object or type created by one of the callers (C#,
VBA) can't be used by the other one. This related to having (or not) a
Primary Interop Assembly as your interop layer for all clients.
--
Phil Wilson
The Definitive Guide to Windows Installer
http://www.apress.com/book/view/1590592972


in message news:[email protected]...