How to share com component between C# and VBA

  • Thread starter Thread starter Sridhar Yada
  • Start date Start date
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.
Click to expand...

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! |
*******************************************
 
Back
Top