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

Any help here??

http://msdn.microsoft.com/en-us/library/dd756403.aspx
--
Gary''s Student - gsnu200909


"QB" wrote:

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

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




"Gary''s Student" wrote:

Any help here??

http://msdn.microsoft.com/en-us/library/dd756403.aspx
--
Gary''s Student - gsnu200909


"QB" wrote:

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

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"QB" wrote in message ...
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




"Gary''s Student" wrote:

Any help here??

http://msdn.microsoft.com/en-us/library/dd756403.aspx
--
Gary''s Student - gsnu200909


"QB" wrote:

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