Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
copy a workbook from other workbook with lot of sheets wit...
how to copy a workbook from other workbook with 10 worksheets with lot of
macros. Last year our company had error with these kind of copied macros files. Please anyone help me to do it in the correct way. Thanks |
#2
|
|||
|
|||
You can open the workbooks in question, press Alt + F11, in the project pane
to the left you can see the macros (module) then just drag them to copy between workbooks, you can also copy and paste them as text (double click the module and a window will open with the code) and you can use macros to do it. Chip Pearson has a lot of info here http://www.cpearson.com/excel/vbe.htm Regards, Peo Sjoblom "Vai" wrote: how to copy a workbook from other workbook with 10 worksheets with lot of macros. Last year our company had error with these kind of copied macros files. Please anyone help me to do it in the correct way. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I save an editable copy of a protected excel workbook? | Excel Discussion (Misc queries) | |||
There is no way to view multiple sheets from one workbook | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) |