Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling a method on an object created in a different addin
I wonder if this is possible. I am a newbie by the way.
Addin1 has a function called obj that returns an object that is created with methods etc. Public Function obj() As MySpecialType ' type from tld com interface On Error Resume Next ' some tuff here to create object End Function In another separate addin (addin2) i need to be able to get a handle to the object and call methods on this object Set localobj = Application.run obj localobj.dostuff...etc I can't get this to work. I must be mis-understanding something. PS, I am trying not to hard code in references if possible. the idea is the code is dynamic, finds if addins are loaded, call methods on those to merge a certain dataset. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling a method on an object created in a different addin
got it working...just needed to appreciate run takes a string. doh. Dim result Dim obj Set obj = Application.Run("somemeth") result = obj.method1 etc... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling for pages before they are created. | Excel Discussion (Misc queries) | |||
Calling addin Function from another workbook? | Excel Programming | |||
Calling a sub from a addin in vba | Excel Programming | |||
Calling an Excel Addin from VBA | Excel Programming | |||
Calling an Excel Addin from VBA | Excel Programming |