MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How do you save a VBA program to a CD ?

  Asked By: Luke    Date: Oct 04    Category: MS Office    Views: 460

How do you save a VBA program to a CD ?



3 Answers Found

Answer #1    Answered By: Archie Parker     Answered On: Oct 04

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.

Answer #2    Answered By: Hamdan Younis     Answered On: Oct 04

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 #3    Answered By: Laaibah Malik     Answered On: Oct 04

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.