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.

-----Original Message-----

wrote in message
...
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.

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

thanks


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


.