com - Calling a third-party public ComVisible .Net method from VBA -
i need call method third-party .net assembly. object want public , marked comvisible attribute. method want public, takes iribboncontrol . so:
[comvisible(true)] public class customui : iribbonextensibility .. ..
public void saveas(iribboncontrol control); is possible, through createobject in vba example? need create iribboncontrol in vba, right?
i know doesn't directly answer question, if setup interface dispids , regasm correctly, "should" able use in vba. test com exposed objects using vbscript tests on machines.
handling vb.net events in vb6 code
obviously vb.net code, attributes etc different format c#. (let me know if need more on part)
can see object register correctly in registry (either search references dll or it's class name).
made sure register dll regasm "path dll" /codebase /tlb if don't register tlb, think vba not able find object.
from vbscript try set myobj = createobject("fullreference.classname") you'll need experiment until have exact name.
then in vba code, add referecnce tlb/dll depending on how registered it.
Comments
Post a Comment