When I'm in VBE is there a way to script the copying of Moduals and Classes
from one project to another. I keep a base project that I enhance, and one in
production;the production file contains data which is augmented each month..
When I've tested out the changes I move the Moduals/Classes/Forms to the
production file.

Of course there is :-). Chip explains it all at
http://www.cpearson.com/excel/vbe.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Helen" wrote in message
...
When I'm in VBE is there a way to script the copying of Moduals and
Classes
from one project to another. I keep a base project that I enhance, and one
in
production;the production file contains data which is augmented each
month..
When I've tested out the changes I move the Moduals/Classes/Forms to the
production file.

hi,
yes.
Open the VB editor in your base project.
on the right, right click the module you wish to transfer.
click export. this will create a text file with a .bas
extention. remember where you exported it to.
then in your production file, open the vb editor.
right click the project name then click import. a dialog
box will apear. select the module you wish to import,
click ok.
this works for modules, forms, ect.
regards
HDR
-----Original Message-----
When I'm in VBE is there a way to script the copying of
Moduals and Classes
from one project to another. I keep a base project that I
enhance, and one in
production;the production file contains data which is
augmented each month..
When I've tested out the changes I move the
Moduals/Classes/Forms to the
production file.
.