Using code to write code

**pspyve** · 08-08-2006, 10:49 PM

Hi guys,
Can we use VBA to write VBA??
ie I am creating workbooks and placing buttons in them and saving them on the company server.
I can get the buttons to exicute a macro that is contained in the original document(xls file). but what I would like to do is actually place the code for those buttons into the automattically created workbook.
The reason for this is when someone else opens one of these workbooks and press' any of the buttons Excel goes looking for the original file with the macros in it and opens it to exicute the code for this particular button.
So I would like to place the code for the buttons inside the workbook that contains the buttons.

Maybe I am looking at this the wrong way, maybe there is another way??
Any ideas??

Phil S

NickHK · 08-08-2006, 11:10 PM

This should get you started:
http://www.cpearson.com/excel/vbe.htm

NickHK

"pspyve" <[email protected]> wrote in
message news:[email protected]...
>
> Hi guys,
> Can we use VBA to write VBA??
> ie I am creating workbooks and placing buttons in them and saving them
> on the company server.
> I can get the buttons to exicute a macro that is contained in the
> original document(xls file). but what I would like to do is actually
> place the code for those buttons into the automattically created
> workbook.
> The reason for this is when someone else opens one of these workbooks
> and press' any of the buttons Excel goes looking for the original file
> with the macros in it and opens it to exicute the code for this
> particular button.
> So I would like to place the code for the buttons inside the workbook
> that contains the buttons.
>
> Maybe I am looking at this the wrong way, maybe there is another way??
> Any ideas??
>
> Phil S
>
>
> --
> pspyve
> ------------------------------------------------------------------------
> pspyve's Profile:
http://www.excelforum.com/member.php...o&userid=30656
> View this thread: http://www.excelforum.com/showthread...hreadid=569737
>