Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-ins customization.
Hi,
I have some routines which needs to be shared by many excel sheets, so planning to move those into an add-in. How can i create an add-in file, and how can i use macros to use routines from that add-ins in my excel sheets? Basically i have one master routines add-in which needs to be utilised in other normal excel sheets. I need to get a way thru macros also to point to the add-ins routines. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-ins customization.
File|SaveAs has an option for addin.
For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) sency wrote: Hi, I have some routines which needs to be shared by many excel sheets, so planning to move those into an add-in. How can i create an add-in file, and how can i use macros to use routines from that add-ins in my excel sheets? Basically i have one master routines add-in which needs to be utilised in other normal excel sheets. I need to get a way thru macros also to point to the add-ins routines. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-ins customization.
Dave, I understood how to include an add-in. In fact, the menuMaker example
worked fine also. But i faced problems when i had tried to use the routines from the add-in. I created an add-in with all generic routines to be shared among different sheets. I included that add-in in my excel, then i tried to access those routines from my different workbooks. It's giving compilation error telling "Sub or Function not defined". "sency" wrote: Hi, I have some routines which needs to be shared by many excel sheets, so planning to move those into an add-in. How can i create an add-in file, and how can i use macros to use routines from that add-ins in my excel sheets? Basically i have one master routines add-in which needs to be utilised in other normal excel sheets. I need to get a way thru macros also to point to the add-ins routines. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-ins customization.
How are you trying to access these routines?
Are you calling them via code or just clicking on the button/menu item? If you're calling them via code, what does your code look like: Is it something like: Application.run "Youraddinname.xla!yourmacroname" There is another option, too. You can create a reference to that addin in the workbook's project that needs it. (use tools|references) Then you can call those macros just like they're built into your project. Call yourmacroname sency wrote: Dave, I understood how to include an add-in. In fact, the menuMaker example worked fine also. But i faced problems when i had tried to use the routines from the add-in. I created an add-in with all generic routines to be shared among different sheets. I included that add-in in my excel, then i tried to access those routines from my different workbooks. It's giving compilation error telling "Sub or Function not defined". "sency" wrote: Hi, I have some routines which needs to be shared by many excel sheets, so planning to move those into an add-in. How can i create an add-in file, and how can i use macros to use routines from that add-ins in my excel sheets? Basically i have one master routines add-in which needs to be utilised in other normal excel sheets. I need to get a way thru macros also to point to the add-ins routines. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
QAT does not allow enough room for customization - please help | Excel Discussion (Misc queries) | |||
Where is Excel Customization? | Excel Programming | |||
Preventing Customization | Excel Programming | |||
Toolbar customization | Excel Programming | |||
Toolbar customization | Excel Programming |