Thread: copy macros?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.setup
John John is offline
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..