#1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 48
Default copy macros?

How do I copy macros from one workbook to another?

Thanks

John
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 709
Default 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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 48
Default 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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 709
Default 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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 48
Default 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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 709
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Tab function not working Curt Excel Discussion (Misc queries) 3 September 27th 06 09:44 PM
Problem with copy and paste together with macros Camper Joe Excel Worksheet Functions 2 August 24th 06 05:24 PM
How to copy 98-97 excel macros to excel 2000 (XP) will A Excel Worksheet Functions 3 November 8th 05 06:37 PM
reminder notifications in a column L Mieth Excel Discussion (Misc queries) 6 June 10th 05 11:00 AM
How to copy a workbook so the buttons run the macros? - Excel Discussion (Misc queries) 4 May 15th 05 11:24 PM


All times are GMT +1. The time now is 02:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"