Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an Excel Add-In
I have a macro that I'd like to make into an Add-In. Can someone direct me
to the procedures I'd need to follow to do this. Thanks in advance, Barb Reinhardt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an Excel Add-In
Hi Barb,
See: How to create an add-in file in Excel 2000 http://support.microsoft.com/default.aspx?kbid=211563. See also Jan Karel Pieterse's comprehensive tutorial at: http://www.jkp-ads.com/Articles/DistributeMacro00.htm --- Regards, Norman "Barb Reinhardt" wrote in message ... I have a macro that I'd like to make into an Add-In. Can someone direct me to the procedures I'd need to follow to do this. Thanks in advance, Barb Reinhardt |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an Excel Add-In
Hi Barb,
For just one Macro, you may be better off putting it into Personal.xls. Add-Ins are generally used to contain a small applet. If you do still want to put your Macro into an Add-In you may like to refer to a good Excel book - like Excel Bible books by John Walkenbach. Alok "Barb Reinhardt" wrote: I have a macro that I'd like to make into an Add-In. Can someone direct me to the procedures I'd need to follow to do this. Thanks in advance, Barb Reinhardt |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an Excel Add-In
How do I invoke the macro once the add-in has been created?
"Norman Jones" wrote: Hi Barb, See: How to create an add-in file in Excel 2000 http://support.microsoft.com/default.aspx?kbid=211563. See also Jan Karel Pieterse's comprehensive tutorial at: http://www.jkp-ads.com/Articles/DistributeMacro00.htm --- Regards, Norman "Barb Reinhardt" wrote in message ... I have a macro that I'd like to make into an Add-In. Can someone direct me to the procedures I'd need to follow to do this. Thanks in advance, Barb Reinhardt |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an Excel Add-In
How do I put it in Personal.xls?
"Alok" wrote: Hi Barb, For just one Macro, you may be better off putting it into Personal.xls. Add-Ins are generally used to contain a small applet. If you do still want to put your Macro into an Add-In you may like to refer to a good Excel book - like Excel Bible books by John Walkenbach. Alok "Barb Reinhardt" wrote: I have a macro that I'd like to make into an Add-In. Can someone direct me to the procedures I'd need to follow to do this. Thanks in advance, Barb Reinhardt |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an Excel Add-In
Barb
Personal.xls is created the first time you record a Macro using Macro Recorder. It is used for making macros available to all open workbooks. ToolsMacroRecord New Macro. A dialog box will come up asking you name the macro and where to place it. Pick Personal Macro Workbook from the dropdown. Copy and paste a couple of cells then Stop Recording. You now have a Personal.xls in your Office\XLSTART folder. You can go to Visual Basic Editor(Alt+F11) to view the macro you just recorded in a Module. You can add more macros by recording or by typing/copying them into the Module. In this case, copy the macro code into the module. You can do a FileSave from there or better yet hit ALT + Q to return to the Excel window. Then with Personal.xls active, hit WindowHide. When you close Excel you will be asked if you want to save Personal.xls. Yes! It will open hidden next time you start Excel. NOTE: when assigning macros to buttons or menu items you will have to precede the macro name with Personal.xls. i.e. Personal.xls!macroname An alternative to Personal.xls is to create an add-in(*.xla) with your macros in it and load it through ToolsAdd-ins. The benefit of this is that you don't have to precede the macro name with the filename. A disadvantage is that you will not see the macros in the ToolsMacroMacros dialog. Gord Dibben Excel MVP On Tue, 22 Nov 2005 14:07:03 -0800, "Barb Reinhardt" wrote: How do I put it in Personal.xls? "Alok" wrote: Hi Barb, For just one Macro, you may be better off putting it into Personal.xls. Add-Ins are generally used to contain a small applet. If you do still want to put your Macro into an Add-In you may like to refer to a good Excel book - like Excel Bible books by John Walkenbach. Alok "Barb Reinhardt" wrote: I have a macro that I'd like to make into an Add-In. Can someone direct me to the procedures I'd need to follow to do this. Thanks in advance, Barb Reinhardt |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an Excel Add-In
Hi Barb,
Did you look at the suggested tutorial? In Section 1, Jan Karel discusses the creation of a macro in a Personal.xls workbook. In Sections 3 and 4, Jan Karel shows how to create a menu or toolbar for the addin's macros. --- Regards, Norman "Barb Reinhardt" wrote in message ... How do I invoke the macro once the add-in has been created? "Norman Jones" wrote: Hi Barb, See: How to create an add-in file in Excel 2000 http://support.microsoft.com/default.aspx?kbid=211563. See also Jan Karel Pieterse's comprehensive tutorial at: http://www.jkp-ads.com/Articles/DistributeMacro00.htm --- Regards, Norman "Barb Reinhardt" wrote in message ... I have a macro that I'd like to make into an Add-In. Can someone direct me to the procedures I'd need to follow to do this. Thanks in advance, Barb Reinhardt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating an Excel TOC | Excel Worksheet Functions | |||
after creating macro button, closed excel then restarted excel | Excel Discussion (Misc queries) | |||
Creating VB OCX that uses MS Excel, but not always | Excel Programming | |||
Creating Excel add-ins from .Net | Excel Programming |