Copy Modules from One workbook to Active Workbook

J

Jim Gifford

I have two different workbooks open. Workbook A = Master Template, Workbook
B = Add on for Template.

Users import the B Workbook into the Master. To keep formatting, I'm using
PasteSpecial Columnwidths, then a Paste into the A Workbook.

But then I need to export any custom VBA modules from Workbook B, then
import then into WorkBook A.

Any suggestions out there.
 
R

Richie UK

Jim Gifford said:
I have two different workbooks open. Workbook A = Master Template, Workbook
B = Add on for Template.

Users import the B Workbook into the Master. To keep formatting, I'm using
PasteSpecial Columnwidths, then a Paste into the A Workbook.

But then I need to export any custom VBA modules from Workbook B, then
import then into WorkBook A.

Any suggestions out there.

----
Jim Gifford

[email protected]
[email protected]
Click to expand...

Hi Jim,

Chip Pearson has a section entitled "Copying Modules Between Projects"
on this page : http://cpearson.com/excel/vbe.htm . Is this what you
had in mind?

HTH
Richie
 
Top