Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you bring one workbook into another workbook?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you bring one workbook into another 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 "PRECO_GIS" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel-how to link source workbook to copy of destination workbook | Excel Worksheet Functions | |||
Bring one sheet from one workbook to another via formula | Excel Discussion (Misc queries) | |||
Excel workbook is corrupted, workbook automatically saves on start | Excel Discussion (Misc queries) | |||
Double Clicking on link w/i workbook does't bring me to souce. | Excel Worksheet Functions | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions |