Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using code to write code
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using code to write code
This should get you started:
http://www.cpearson.com/excel/vbe.htm NickHK "pspyve" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using code to write code
I just had a quick squiz at that site and it looks just perfect..... Many thanks 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Write Code w/VBA | Excel Programming | |||
Code to write out all lines of code | Excel Programming | |||
Write a code by code | Excel Discussion (Misc queries) | |||
Write a code with another code | Excel Programming | |||
How can i write TSR code | Excel Programming |