Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Excel Macro
I have a VB Macro in an Excel spreadsheet that I want to use in other
spreadsheets. What is the most efficient way to do this without copying the macro code from sheet to sheet. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Excel Macro
It depends on how that macro is written (and what it does).
It could be as simple as opening the macro workbook, activating the "real" workbook and the sheet that should be processed, then hitting alt-F8 and selecting the macro and running it. This could even work if the code was written to work on the activesheet <bg. ajmplanner wrote: I have a VB Macro in an Excel spreadsheet that I want to use in other spreadsheets. What is the most efficient way to do this without copying the macro code from sheet to sheet. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Excel Macro
When you say spreadsheet are you referring to a worksheet within a file or
to the file itself. What kind of macro. Always BEST to post YOUR macro for comments. -- Don Guillett Microsoft MVP Excel SalesAid Software "ajmplanner" wrote in message ... I have a VB Macro in an Excel spreadsheet that I want to use in other spreadsheets. What is the most efficient way to do this without copying the macro code from sheet to sheet. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Excel Macro
Thanks for your replies. The macro simply parses some information in a cell
of each row of a worksheet and places the parsed info in other columns on that row. I receive the unparsed information in a different Excel file each month. I was under the impression that a macro built for that worksheet was "attached" to that Excel file and could not access worsheets in another Excel file. "Dave Peterson" wrote: It depends on how that macro is written (and what it does). It could be as simple as opening the macro workbook, activating the "real" workbook and the sheet that should be processed, then hitting alt-F8 and selecting the macro and running it. This could even work if the code was written to work on the activesheet <bg. ajmplanner wrote: I have a VB Macro in an Excel spreadsheet that I want to use in other spreadsheets. What is the most efficient way to do this without copying the macro code from sheet to sheet. -- Dave Peterson . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Excel Macro
You use three terms............spreadsheet, worksheet and file.
Do you mean workbook and worksheet? Do you have a simple macro like Sub Macro() do things End Sub Or is the code a worksheet event type like worksheet_change? If a simple macro, create an add-in from a workbook with the macro in a module. Add that add-in to your list of installed and loaded add-ins. The macro will be availanle for all open workbooks. Or if just for your own use, place the macro in your Personal.xls workbook. If event type code, you will have to post it so's we can figure out the best method of making available. Gord Dibben MS Excel MVP On Thu, 4 Mar 2010 08:34:01 -0800, ajmplanner wrote: Thanks for your replies. The macro simply parses some information in a cell of each row of a worksheet and places the parsed info in other columns on that row. I receive the unparsed information in a different Excel file each month. I was under the impression that a macro built for that worksheet was "attached" to that Excel file and could not access worsheets in another Excel file. "Dave Peterson" wrote: It depends on how that macro is written (and what it does). It could be as simple as opening the macro workbook, activating the "real" workbook and the sheet that should be processed, then hitting alt-F8 and selecting the macro and running it. This could even work if the code was written to work on the activesheet <bg. ajmplanner wrote: I have a VB Macro in an Excel spreadsheet that I want to use in other spreadsheets. What is the most efficient way to do this without copying the macro code from sheet to sheet. -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming |