Trigger an Excel VBA event from another application
Mike,
You can call a method in Excel VBA from .NET assembly but you cannot
get an event back in the assembly from VBA code.
If this is what you want to do, get the Primary Interop Assemblies for
Excel, reference them in your .NET project and use the
Excel.Application object. A method named "Run" is used to call a VBA
macro.
regards
|