Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Macros and VB code from one workbook to another
I have copied a production workbook to a test environment
and created some macros and vb code to go along with the workbook. From the time I copied the book to test a lot of changes have taken place to the production book. How do I copy or move the macros and vb code from the test version to the production version? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Macros and VB code from one workbook to another
Dawn,
For help on doing this in VBA, take a look he http://www.cpearson.com/excel/vbe.htm Manually, you can open the VBA editor and export each of the modules from the "test" version and import them to the "production" version. Easier way is to open both workbooks and from the VBA editor and just drag and drop modules and userforms from one to the other. John "Dawn" wrote in message ... I have copied a production workbook to a test environment and created some macros and vb code to go along with the workbook. From the time I copied the book to test a lot of changes have taken place to the production book. How do I copy or move the macros and vb code from the test version to the production version? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help...Code to copy sheet from closed workbook | Excel Discussion (Misc queries) | |||
copy and paste using code from workbook to workbook | Excel Discussion (Misc queries) | |||
How to copy a workbook so the buttons run the macros? | Excel Discussion (Misc queries) | |||
Copy worksheet, code and all, into workbook? | Excel Programming | |||
Copy VB code to other workbook? | Excel Programming |