If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
copy macros?
How do I copy macros from one workbook to another?
Thanks John |
#2
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|