call a sub in a class from another class/Designer (IRibbonExtensibility)
Hi
I´ve implemented a class Designer (DSR) with the IRibbonExtensibility in my Excel Activecex dll. So far so (more or less) good...
The problem is that i can only call (in the ribbon) procedures that are inside the ribbon class/Designer.
How can i can i call procedures in another class or even in a module?
Thanks a lot... and sorry for the newbi questions...
Jorge
Re: call a sub in a class from another class/Designer (IRibbonExtensibility)
Re: call a sub in a class from another class/Designer (IRibbonExtensibility)
I admit, I don't fully understand the statement "How can i can i call procedures in another class or even in a module?" Are you talking about calling something within your own activex dll? If so, you provide a public function/sub in a class exposed by the dll. The function/sub can then call anything in your dll project.
Re: call a sub in a class from another class/Designer (IRibbonExtensibility)
Hi
Figured it out!
Im talking about Activex Dll for Excel (how to make a ribbon in vb6 trough office IRibbonExtensibility)
Well for this to work you have to create a Designer file, implement the IRibbonExtensibility (Implements IRibbonExtensibility)
And make sure that all the subs you call in the ribbon are inside the deginer file.
And of course reference microsoft office XX.0 object library
The procedure shloud begin something like: Public Sub yoursubname (ByVal control As IRibbonControl)
and have this function in the designer file:
Public Function IRibbonExtensibility_GetCustomUI(ByVal RibbonID As String) As String
IRibbonExtensibility_GetCustomUI = GetRibbonXML()
End Function
Thats it.
thanks everyone for the replys!
Abny questions be free to PM me...
Cheers
Jorge