Can you bring one workbook into another workbook?

  • Thread starter Thread starter PRECO_GIS
  • Start date Start date
P

PRECO_GIS

I have two separate workbooks that were previously set up for me with macros
included... both work separately in their own rights, however I would like to
be able to blend them... I do not have VB skills to speak of (I am more of a
SQL admin).

How can I bring the best of both of these workbooks together into a new
workbook?
 
In the VB editor you can drag all modules, classes and forms from one file
("project") into the other in the project editor. Then in Excel select all
sheet tabs at once, rightclick, "move or copy", move to the other file.

You may/will encounter problems if macros or functions are named the same,
sheets are named the same, ranges are named the same in the two files. Also
there will be problems if macros address sheets by index instead of names.

HTH. Best wishes Harald
 
Back
Top