Embed a .txt file in Excel Workbook for dynamicMenu getContent?

[VBE313]

I have a custom ribbon in this Excel file, and below is a group in my manifest.xml file. I have the the getContent going to a macro called "RDBdynamicMenuContent2." Is there a way to embed MYPath file path into this workbook? Instead of reading the Contacts.txt file from this J drive, can I embed this file like a Manifest.xml file?

Public Sub RDBdynamicMenuContent2(control As IRibbonControl, ByRef returnedVal)
    Dim MYPath As String
    Dim xml As String
  [B]  MYPath = "J:\Industries\1126\Bad files\BOM\RMFGContacts.txt"[/B]
    xml = LoadTextFile(MYPath)
    returnedVal = xml
    On Error Resume Next
    rib.InvalidateControl ("RDBDynamicMenu")
End Sub

   <group id="PeopleButtons" label="To/From" >
        <dynamicMenu id="RDBDynamicMenu" getContent="RDBdynamicMenuContent2" imageMso="AddUserToPermissionGroup" label="Choose Author and Customer" size="large" supertip="Auto-populate the Author and Internal Customer" />
   </group>

 

[jkpieterse]

Depends on your needs I guess, you can "embed" the xml as a string constant in your VBA:

Const RibbonX as String = "<group id=""PeopleButtons"" label=""To/From"" ><dynamicMenu id=""RDBDynamicMenu"" getContent=""RDBdynamicMenuContent2"" imageMso=""AddUserToPermissionGroup"" label=""Choose Author and Customer"" size=""large"" supertip=""Auto-populate the Author and Internal Customer"" /></group>"

 

[VBE313]

Hi Mr. Pieterse,

Thanks for the response. The reason why I want to "embed" it, is because not all the users have access to that part of the J Drive. I just want the dynamic menu to be used without referencing that .txt file.
I am brand new with string constants. Does the string constant need to be in the same module as the sub procedure? Also, do i change anything in the manifest? Thank you!

P.S.

I love your website and you have helped me with so many things throughout my project (last 14 months). Thank you very much for all the content you post!

 

[jkpieterse]

Hmm, given that this is fixed, why not put it in the RibbonX inside the file directly?

 

[VBE313]

Hmm, given that this is fixed, why not put it in the RibbonX inside the file directly?

The Manifest.xml file is not what I need to be in the file. I already have the manifest.xml. The actual data that makes up the dynamicMenu is what I need to embed into the file. So my manifest.xml file uses the getContent"RDBdynamicMenuContent2" which then calls this .txt file(see photo) to create my dynamicMenu.

 

[VBE313]

Home | Ron de Bruin Excel Automation

Welcome to https://www.rondebruin.nl

www.rondebruin.nl

Ron De Bruin was the Subject Matter Expert that I was following when creating the dynamicMenu.

 

[VBE313]

https://www.rondebruin.nl/win/winfiles/DynamicMenuWindows.zip

Ron De Bruin was the Subject Matter Expert that I was following when creating the dynamicMenu.

 

[jkpieterse]

I'm sorry, I don't understand. Can you please try to explain in different wording, what it is you are trying to achieve?