call a sub in a class from another class/Designer (IRibbonExtensibility)

[Jorge Santos]

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

[Jorge Santos]

Anyone on this?

Thanks!!

[LaVolpe]

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.

[Jorge Santos]

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