Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
copy macros?
How do I copy macros from one workbook to another?
Thanks John |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
copy macros?
John,
You can drag and drop the modules from one workbook to another in the VBA editor, just open the workbooks and drag and drop. You can also insert a blank module in the other workbook and copy an paste the parts that you want. Or if it on another computer you can export a macro and save it, to do this from your workbook, right-click the workbook's icon and pick View Code. This icon is to the left of the "File" menu this will open the VBA editor, in Project Explorer right click on your workbook name, if you don't see it press CTRL + r to open the Project Explorer click on the module you want to save and go to file and export file, then save it to a floppy or what ever you backup to, then import it to the new workbook.. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "John" wrote in message ... How do I copy macros from one workbook to another? Thanks John |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
copy macros?
Could you be more specific? I get them both open and in VBA but I don't
see how to drag the module. O know how to export/import. I can get all the macros to a file and then import them but it's a pain because you have to do it one at a time. Thanks John Paul B wrote: John, You can drag and drop the modules from one workbook to another in the VBA editor, just open the workbooks and drag and drop. You can also insert a blank module in the other workbook and copy an paste the parts that you want. Or if it on another computer you can export a macro and save it, to do this from your workbook, right-click the workbook's icon and pick View Code. This icon is to the left of the "File" menu this will open the VBA editor, in Project Explorer right click on your workbook name, if you don't see it press CTRL + r to open the Project Explorer click on the module you want to save and go to file and export file, then save it to a floppy or what ever you backup to, then import it to the new workbook.. |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
copy macros?
John, when you have both open and in VBA, click on the module you want to
copy, left click and hold the mouse button down and drag it to the other workbook, as far as I know you have to export and import one module at a time using file, export, import. Can you put all the macros in on module and then just export it? -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "John" wrote in message ... Could you be more specific? I get them both open and in VBA but I don't see how to drag the module. O know how to export/import. I can get all the macros to a file and then import them but it's a pain because you have to do it one at a time. Thanks John Paul B wrote: John, You can drag and drop the modules from one workbook to another in the VBA editor, just open the workbooks and drag and drop. You can also insert a blank module in the other workbook and copy an paste the parts that you want. Or if it on another computer you can export a macro and save it, to do this from your workbook, right-click the workbook's icon and pick View Code. This icon is to the left of the "File" menu this will open the VBA editor, in Project Explorer right click on your workbook name, if you don't see it press CTRL + r to open the Project Explorer click on the module you want to save and go to file and export file, then save it to a floppy or what ever you backup to, then import it to the new workbook.. |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
copy macros?
Ok... now I got it. I had to create a module in the new workbook. Then I
could drag the macros to it. Without any macros and hence no module in the new workbook there was nothing to drag to. Thanks John Paul B wrote: John, when you have both open and in VBA, click on the module you want to copy, left click and hold the mouse button down and drag it to the other workbook, as far as I know you have to export and import one module at a time using file, export, import. Can you put all the macros in on module and then just export it? |
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
copy macros?
John, you can just drag it to the workbook name and it will put the module
in for you -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "John" wrote in message ... Ok... now I got it. I had to create a module in the new workbook. Then I could drag the macros to it. Without any macros and hence no module in the new workbook there was nothing to drag to. Thanks John Paul B wrote: John, when you have both open and in VBA, click on the module you want to copy, left click and hold the mouse button down and drag it to the other workbook, as far as I know you have to export and import one module at a time using file, export, import. Can you put all the macros in on module and then just export it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Tab function not working | Excel Discussion (Misc queries) | |||
Problem with copy and paste together with macros | Excel Worksheet Functions | |||
How to copy 98-97 excel macros to excel 2000 (XP) | Excel Worksheet Functions | |||
reminder notifications in a column | Excel Discussion (Misc queries) | |||
How to copy a workbook so the buttons run the macros? | Excel Discussion (Misc queries) |