Copy Modules from One workbook to Active Workbook

  • Thread starter Thread starter Jim Gifford
  • Start date Start date
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.
 
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

(e-mail address removed)
(e-mail address removed)
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
 
Back
Top