Copy Modules from One workbook to Active Workbook

[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.

 

[Richie UK]

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

(e-mail address removed)
(e-mail address removed)

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