| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy one macro to another workbook
hello all, I am looking to copy a macro from one workbook on my hard drive
to another workbook that is located on a server. is there an easy way to accomplish this as I have a number of workbooks that need the same treatment. Thanks again, everyone for the great questions and the superb answers!! J -- Go Navy !!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy one macro to another workbook
On Sep 4, 6:22 am, Jay wrote:
hello all, I am looking to copy a macro from one workbook on my hard drive to another workbook that is located on a server. is there an easy way to accomplish this as I have a number of workbooks that need the same treatment. Thanks again, everyone for the great questions and the superb answers!! J -- Go Navy !!!! Open both workbooks. Go into VBA (ALT-F11) and open the Project Explorer (CTRL-R). You can either open a module and copy the text of the macro to a new Module in the 2nd workbook or just drag an entire module to the other workbook in the Explorer and it will copy. Don't forget to save. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy one macro to another workbook
Roger that, I was hoping it was an easy fix. I really enjoy coming on
this web page and learning more and more excel everyday. HooRah Go Navy! -- Cheers! "Spiky" wrote: On Sep 4, 6:22 am, Jay wrote: hello all, I am looking to copy a macro from one workbook on my hard drive to another workbook that is located on a server. is there an easy way to accomplish this as I have a number of workbooks that need the same treatment. Thanks again, everyone for the great questions and the superb answers!! J -- Go Navy !!!! Open both workbooks. Go into VBA (ALT-F11) and open the Project Explorer (CTRL-R). You can either open a module and copy the text of the macro to a new Module in the 2nd workbook or just drag an entire module to the other workbook in the Explorer and it will copy. Don't forget to save. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy an image (or picture) from one workbook to a new sheetin another workbook | Excel Worksheet Functions | |||
| Copy workbook, don't copy macro | Excel Discussion (Misc queries) | |||
| Macro to Copy From One Workbook To Another | Excel Discussion (Misc queries) | |||
| How can I copy a macro into another workbook? | New Users to Excel | |||
| Copy macro to another workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
