Get Ribbon File Name

[kal0123456789]

Is there a way to get the name of the ribbon that we're using when we import the ribbon to workbook? Probably using onLoad function?

This is the sample code on the ribbon:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" onLoad="onLoad">
   <ribbon>
    <tabs>
      <tab id="MyTab" label="Custom">
          Bunch of stuff here        
      </tab>
    </tabs>
  </ribbon>
</customUI>

This is the vba code of onLoad:

Public myRibbon As IRibbonUI
Sub onLoad(ribbon As IRibbonUI)
    Set myRibbon = ribbon
    <Get filename here>
End Sub

 

[RoryA]

A gentle reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Get Ribbon File Name

Is there a way to get the name of the ribbon that we're using when we import the ribbon to workbook? Probably using "onLoad" function? This question has been in the MrExcel(sorry cannot give any links due to insufficient total posts), so I'll ask again after several days/weeks. If there is a...

www.excelforum.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[kal0123456789]

Thank you for reminding! I'll refrain from cross-posting until several time(days/weeks) has been reached, then. By the way, for this post, I'm sticking with this first(hopefully can remove the other forum's post to remove the cross-posting)