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" <(E-Mail Removed)> wrote in message news:04789826-4780-43C2-AAF7-(E-Mail Removed)...
> 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