Excell VBA

[Eugene]

I am using a third party addin in Excell. I would like to access it's funcion programatically but I don't know how to identify the object in order to execute it's function from code. Any ideas will be greatly appreciated. Thanks
This message was edited by Eugene on 2002-03-09 09:42

 

[Barrie Davidson]

On 2002-03-09 09:41, Eugene wrote:
I am using a third party addin in Excell. I would like to access it's funcion programatically but I don't know how to identify the object in order to execute it's function from code. Any ideas will be greatly appreciated. Thanks
This message was edited by Eugene on 2002-03-09 09:42

A quick cheat - have you tried recording a macro that accesses your add-in and then take a look at the code generated by Excel?



_________________

Barrie Davidson
My Excel Web Page
This message was edited by Barrie Davidson on 2002-03-09 09:56

 

[dk]

Well assuming it can be accessed programmatically then you just need to set a reference to the add-in on the Tools, References menu item in the VB editor. Then in code you'd do something like this:-

AddinName.MethodName (the procedure you want to run from the code)


HTH,
D

 

[dk]

Well assuming it can be accessed programmatically then you just need to set a reference to the add-in on the Tools, References menu item in the VB editor. Then in code you'd do something like this:-

AddinName.MethodName (the procedure you want to run from the code)


HTH,
D

 

[dk]

Well assuming it can be accessed programmatically then you just need to set a reference to the add-in on the Tools, References menu item in the VB editor. Then in code you'd do something like this:-

AddinName.MethodName (the procedure you want to run from the code)


HTH,
D

 

[dk]

Sorry, don't know what happened there - is the board behaving badly today (i.e. quite slow to load) or is it just me?

Regards,
Dan