Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy selected macro(s) to a different workbook
Hello
I know that a whole module can be exported/imported into a different workbook, but is it possible to select macros from a module and copy them to a different workbook. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy selected macro(s) to a different workbook
hi
yes. high light all or any part of the code then copy. in this respect, it's not unlike coping and pasting in notepad. just be carefull where you paste. Regards FSt1 "Cresta" wrote: Hello I know that a whole module can be exported/imported into a different workbook, but is it possible to select macros from a module and copy them to a different workbook. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy selected macro(s) to a different workbook
Sorry I should have been a bit more specific. The copying is to be done by a
macro. "FSt1" wrote: hi yes. high light all or any part of the code then copy. in this respect, it's not unlike coping and pasting in notepad. just be carefull where you paste. Regards FSt1 "Cresta" wrote: Hello I know that a whole module can be exported/imported into a different workbook, but is it possible to select macros from a module and copy them to a different workbook. Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy selected macro(s) to a different workbook
hi
opps. see this site http://cpearson.com/excel/vbe.aspx regards FSt1 "Cresta" wrote: Sorry I should have been a bit more specific. The copying is to be done by a macro. "FSt1" wrote: hi yes. high light all or any part of the code then copy. in this respect, it's not unlike coping and pasting in notepad. just be carefull where you paste. Regards FSt1 "Cresta" wrote: Hello I know that a whole module can be exported/imported into a different workbook, but is it possible to select macros from a module and copy them to a different workbook. Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy selected macro(s) to a different workbook
Thanks FSt1, that looks like it will do the trick.
"FSt1" wrote: hi opps. see this site http://cpearson.com/excel/vbe.aspx regards FSt1 "Cresta" wrote: Sorry I should have been a bit more specific. The copying is to be done by a macro. "FSt1" wrote: hi yes. high light all or any part of the code then copy. in this respect, it's not unlike coping and pasting in notepad. just be carefull where you paste. Regards FSt1 "Cresta" wrote: Hello I know that a whole module can be exported/imported into a different workbook, but is it possible to select macros from a module and copy them to a different workbook. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy selected tabs from multiple workbooks to a new workbook | Excel Worksheet Functions | |||
Copy a selected Range to a Workbook | Excel Programming | |||
copy selected cells to new workbook? | Excel Programming | |||
how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) | |||
Copy selected data to new workbook | Excel Programming |