Get Ribbon File Name

**kal0123456789** · 01-19-2022, 07:21 AM

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 way to remove this post, I'll be happy to take down this post. Sorry for disturbing.

This is the sample code on the ribbon:

HTML Code:

This is the vba code of onLoad:

Please Login or Register  to view this content.

**AB33** · 01-19-2022, 10:38 AM

Not sure I understand your request. I believe this code was designed by Ron de Bruin.
https://www.rondebruin.nl/win/s2/win001.htm
I have not accessed it for over two years, so no not sure if he is still active

**kal0123456789** · 01-19-2022, 10:48 AM

I thought I need to ask in the other day, but since you have replied, I'll answer then.

Supposedly the XML customUI file is "custom.exportedUI". I want the "custom.exportedUI" file name to be known in VBA, so I know that it's from "custom.exportedUI", not from for example "custom2.exportedUI" file. Since the file name can probably be seen when it's being imported to Excel, is there a way to grab the file name by VBA?

**AB33** · 01-19-2022, 11:37 AM

The simple answer is I do not know, but if I were to guess "custom.exportedUI" is part of XML language, You need to run a code to specifically parse the name—XML parser.

Get Ribbon File Name

LinkBack

Thread Tools

Rate This Thread

Display

Get Ribbon File Name

Re: Get Ribbon File Name

Re: Get Ribbon File Name

Re: Get Ribbon File Name

Thread Information

Users Browsing this Thread

Similar Threads

File on the ribbon not there

Where does this file's custom ribbon tab come from?

[SOLVED] How does one activate ribbon components from an xlam file ?

[SOLVED] Excel 2007-Customize the Ribbon using a xlam file instead of a xlsm file.

[SOLVED] Customize Excel Ribbon When File Opens

[SOLVED] Ribbon Edit the existing file

Excel 2007 : Remove formula bar from ribbon on a 2007 file

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions