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

(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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pulling data from one workbook to another one using VBA 0
Import multiple workbooks to current workbook in specified row number 0
Scattered array cells copy to scattered array cells another workbook 14
Update #REF! to Active Workbook 1
How to append data from different sheet and different workbook? 2
copy and paste from workbook to workbook 3
Cell values to an array, then array transpose to another workbook 8
How to copy a workbook 8

Top