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




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