add customui ribbon tab to a existing workbook

[QB]

I use vba to create a new workbook. I now need to add in a customui from
code with the associated vba code that goes alog with it. How can this be
achieved?

I have no issue creating the customui but how do I add it to another
workbook using vba (along with the required callbacks and modules)?

Thank you,

QB

 

[Gary''s Student]

Any help here??

http://msdn.microsoft.com/en-us/library/dd756403.aspx

 

[QB]

Perhaps I should reexplain.

I have a xlsm that I use to generate another xlsm. I now need, as part of
the creation process, attach a customui ribbon, vba code and callback (for
the ribbon). How can I do it? I have all of these as part of the xlsm
(there is a lot more code, but I do not require or want it all, just a
selected module) that generates the other xlsm, I just need to know how to
transfer, include it ito the new xlsm.

Thank you for your help.

QB

 

[Ron de Bruin]

Hi QB

You must make it a zip and add the file and make it a xlsm after you ready

If you download the RDBQAT add-in from this page and look at the code you have a good start
http://www.rondebruin.nl/imageqat.htm