Copy Macros and VB code from one workbook to another

  • Thread starter Thread starter Dawn
  • Start date Start date
D

Dawn

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?
 
Dawn,

For help on doing this in VBA, take a look here:
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
 
Back
Top