Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting a Macro
Good Morning,
I have been given an excel spreadsheet that has an excellent interpolation marco in it. I now want to use this macro on another spreadsheet. Does anyone know how i can copy the makro from one sheet to another? Is it possible to save frequently used macros's into a directory where i can pull then out from when required? Thanks very much. Andy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting a Macro
See http://www.mrexcel.com/articles/past...o-into-vbe.php
instead of copying from the website you will have to copy the macro from your spreadsheet with the macro you want. Ideally frequently used macros are written in PERSONAL.xls which is available to all workbooks. See http://visualbasic.about.com/od/lear.../aa022203a.htm to start learning about it. "Andy" wrote: Good Morning, I have been given an excel spreadsheet that has an excellent interpolation marco in it. I now want to use this macro on another spreadsheet. Does anyone know how i can copy the makro from one sheet to another? Is it possible to save frequently used macros's into a directory where i can pull then out from when required? Thanks very much. Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting | Excel Worksheet Functions | |||
exporting | Excel Discussion (Misc queries) | |||
Exporting | Excel Discussion (Misc queries) | |||
exporting | Excel Discussion (Misc queries) | |||
exporting to CSV | Excel Worksheet Functions |