Implementing an Excel 2007 AddIn

Posted on 2011-09-17
Medium Priority
Last Modified: 2012-05-12
I've created several VBA subroutines that I want to be able to run from within multiple workbooks.

I copied all of the code into a new workbook, and saved the file as a .xlam file.

I went into the Excel Options, selected the Addins, found my xlam file and added it.  But I don't see any way to call these subroutines.  I thought they would show up as drop-downs or options in the Add-Ins tab, but dont' see them.

In the workbook I was developing in, I just called the subroutines from the Click event of a command button, but would prefer not to have to put the command buttons on each workbook that would use this code.
Question by:Dale Fye
  • 3
LVL 42

Accepted Solution

dlmille earned 2000 total points
ID: 36555401
If you want to run these routines from the Add-ins menubar, here's an excellent option for you.

Check out this tip, and let me know if you need further assistance.


LVL 85

Expert Comment

by:Rory Archibald
ID: 36559293
If you would prefer to create your own tabs/groups/buttons to run the code, then check out Ron's site here: http://www.rondebruin.nl/ribbon.htm

It's really not as bad as it may look at first glance. ;)

LVL 50

Author Comment

by:Dale Fye
ID: 36955848
Have not had a chance to implement this yet.  Hopefully will get to it this week.
LVL 50

Author Comment

by:Dale Fye
ID: 37008678

I've finally gotten a chance to readdress this.  

I downloaded your xlam file from that link, and save it at: C:\Users\dale.fye\AppData\Roaming\Microsoft\AddIns

Is there another folder location where this would be more broadly available to other users?  Something like:
C:\Program Files\Microsoft Office\Office12\ADDINS

I'm far from an Excel expert (Access is my VBA of choice).  How do I then get this loaded so that it is available for my users whenever they open any of their worksheets?  

Do I need to modify any of the code in these macros to refer to the activeworkbook, rather than the workbook that contains the macro code?

If these macros depend on certain worksheets being available in the active workbook, I assume that I should add code to my macros so that they search for those worksheets and if not in the active workbook, I would display an error message.
LVL 50

Author Closing Comment

by:Dale Fye
ID: 37008770
Disregard.  I figured it out.

Dave, that works great.  Sorry it took so long to get back to this.

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question