MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How do you save a VBA program to a CD ?

  Asked By: Claude    Date: Oct 25    Category: MS Office    Views: 1559

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.



2 Answers Found

Answer #1    Answered By: Adali Fischer     Answered On: Oct 25

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.

Answer #2    Answered By: Olga Kates     Answered On: Oct 25

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.

Didn't find what you were looking for? Find more on How do you save a VBA program to a CD ? Or get search suggestion and latest updates.