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.