View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Lovern Greg Lovern is offline
external usenet poster
 
Posts: 224
Default How to run macro from an exe?

I have an .xla add-in that instantiates a COM server exe. That part
works fine, but I want to have the COM server EXE run a macro in
the .xla add-in. Any suggestions on how best to do that?

If I define an object in a class module in the .xla add-in, can the
exe instantiate it? I assume it won't be registered, so CreateObject
wouldn't work.


Thanks,

Greg