Solved

Implementing an Excel 2007 AddIn

Posted on 2011-09-17
5
232 Views
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.
0
Comment
Question by:Dale Fye (Access MVP)
  • 3
5 Comments
 
LVL 41

Accepted Solution

by:
dlmille earned 500 total points
Comment Utility
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.

http:/Q_26837274.html

Dave
0
 
LVL 85

Expert Comment

by:Rory Archibald
Comment Utility
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. ;)

Regards,
Rory
0
 
LVL 47

Author Comment

by:Dale Fye (Access MVP)
Comment Utility
Have not had a chance to implement this yet.  Hopefully will get to it this week.
0
 
LVL 47

Author Comment

by:Dale Fye (Access MVP)
Comment Utility
Dave,

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.
0
 
LVL 47

Author Closing Comment

by:Dale Fye (Access MVP)
Comment Utility
Disregard.  I figured it out.

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

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Outlook Free & Paid Tools
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now