View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RyanH RyanH is offline
external usenet poster
 
Posts: 586
Default Ribbon Button not Working with my Referenced Workbook

I have a workbook named "Global Schedule" that my users open with Excel
versions 2003 and 2007. I have a 2003 Add-In that I reference which contains
all of the code to manipulate the Global Schedule.

If 2003 opens the Global Schedule I have code to add a custom popup menu
with some control buttons. These buttons do custom sorts to the Global
Schedule. This part works beautifully.

If 2007 is used to open the Global Schedule then a 2007 Add-In is only used
to change the Ribbon which also contains custom buttons to do my custom
sorts. I want these buttons to call the same procedures that are located in
the referenced workbook - 2003 Add-In. Can I not call procedures from a
referenced workbook in XML? The problem happens when I click the Ribbon
control butttons. I get an Error: "Wrong Number of Arguements or Invalid
Property Assignment." I checked the XML code in the CustomUI Editor and the
buttons onAction has the correct procedure pointing to the 2003 Add-In
reference. I'm not sure what this means because my procedures that the
control button calls does not require arguements. Does anyone have any ideas?

Here is my basic setup:

'GLOBAL SCHEDULE CODE:
Private Sub Workbook_Open()

If Val(Application.Version) 11 Then
' open 2007 Add-In which contains XML to change Ribbon
Else
Call CustomMenuControl(ThisWorkbook)
End If

End Sub

The 2003 Add-In is always open no matter which version of Excel is used
because it contains several modules that I reference to manipulate the Global
Schedule Data.
--
Cheers,
Ryan