copy macros?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 26 Oct 2006 21:18 GMT

How do I copy macros from one workbook to another?

Thanks

John

Reply to this Message

Paul B - 27 Oct 2006 01:04 GMT

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..

Signature

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

> How do I copy macros from one workbook to another?
>
> Thanks
>
> John

Reply to this Message

John - 27 Oct 2006 20:03 GMT

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

> John,
> You can drag and drop the modules from one workbook to another in the VBA
[quoted text clipped - 7 lines]
> 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..

Reply to this Message

Paul B - 27 Oct 2006 20:35 GMT

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?

Signature

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

> 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
[quoted text clipped - 22 lines]
>> ever
>> you backup to, then import it to the new workbook..

Reply to this Message

John - 27 Oct 2006 21:50 GMT

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

> 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 to this Message

Paul B - 27 Oct 2006 23:07 GMT

John, you can just drag it to the workbook name and it will put the module
in for you

Signature

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

> 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
[quoted text clipped - 9 lines]
> > time using file, export, import. Can you put all the macros in on module and
> > then just export it?

Reply to this Message