Dale Fye
asked on
Implementing an Excel 2007 AddIn
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Have not had a chance to implement this yet. Hopefully will get to it this week.
ASKER
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\Mi crosoft\Ad dIns
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.
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\
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.
ASKER
Disregard. I figured it out.
Dave, that works great. Sorry it took so long to get back to this.
Dave, that works great. Sorry it took so long to get back to this.
It's really not as bad as it may look at first glance. ;)
Regards,
Rory