There are two ways. One is to recognize that VBA is always part of a 10
application file pedes right ExcelVBA. It is part of an excel file and the
new right word of VBA is part of the Word file. Therefore, you can save  VBA
by saving on the underlying file which contains it to the CD.


An alternative is to copy the text from the VBE and paste it into another file
such as a text file in notepad. You could then save the text file to the CD.

If you use, the second method, to reuse the VBA you would need to open the
text file, copy it, and past it back into the VBE.

You can use the Export command within the VBA editor to save  the VBA module
to a text file and use the Import command to bring the text file back into
the VBA editor.

however, for the second method, there is another,
perhaps better alternative, which is to use File / Export File.. from the
VBA editor. Using this command, you can save  each Form and Code Module into
a disk file, which is mostly text, except for the form layout. Then, you
would need to do a File / Import File on the other end.