How to copy VBA project?

C

cubus

How to copy VBA project (macros) from one workbook to another
workbook(create exact copy)? Please show in detail.

thanks
 
J

JulieD

hi

open both workbooks
in the VBE window display the project explorer
click on the module that you want to copy to the other workbook in the
project explorer
drag it to the workbook name and let the mouse go
the module will be copied there.

Cheers
JulieD
 
G

Guest

hi.
open the vb editor Alt+F11
in the left pane (vb projects), right click the project
you wish to export. (expand the trees if neccessary.)
click export on the popup menu.
The project will be exported as a .bas file(text).
default destination will be office directory.

to import to another file, open the file.
open the vb editor. right click the file name in the vb
project pane (left). click import on the popup menu.
 
C

cubus

hi.
open the vb editor Alt+F11
in the left pane (vb projects), right click the project
you wish to export. (expand the trees if neccessary.)
click export on the popup menu.
The project will be exported as a .bas file(text).
default destination will be office directory.

to import to another file, open the file.
open the vb editor. right click the file name in the vb
project pane (left). click import on the popup menu.
Click to expand...


Some note: I want *all* VBA content of given workbook to be copied, not just
separate modules.
 
G

Guest

hi again,
If that be the case, it may be easier to copy the WB to a
new name and delete the data from the new WB.
The way i discribed is for 1 project at a time.
JulieD has a good idea too.
 
B

Bob Phillips

Your answer sounded like it was complaining about the advice offered ...
Some note:
 
Top