How do I save as XLAM Excel add-in
I have some code that I want to use in Excel as an add-in. I have Excel 2007 and VB Express 2008 installed on XP Pro SP3.
I see everyone saying to "save as XLAM Excel add-in" on forums and sties, but can't find that option anywhere on my apps.
What am I missing?
Software/Hardware used:
XP Pro SP3, Office 2007 VB express 2008
Software/Hardware used:
XP Pro SP3, Office 2007 VB express 2008
ASKED:
February 26, 2010 8:41 PM
UPDATED:
May 8, 2013 3:52 PM
Answer Wiki:
Assuming this code is in a module atttached to an open workbook in Excel 2007:
Click the Office Button, Save As, click Other Formats, and on the 'Save As' dialogue, drop down the choices in 'Save as type' and select Excel Add-In (*.xlam). On my system, it's about 5th position from the bottom of the file type list.
To enbale the Add-In, you'll need to use the add-in manager that's in the Excel Options dialogue (Office Button, Excel Options, Add-Ins, Manage Add-Ins...).
To see all answers submitted to the Answer Wiki: View Answer History.
Did anyone ever get back to you on this question? I’m experiencing the same issue and it’s frustrating.
You can force it to save as an add-in (using code), but I’m really not sure why it isnt appearing in my Save as file type list.
Cheers, Sam
No, haven’t had any input or responses other than yours.
This was all related to the “send file by email” right-click option inside or Word and Excel.
We wanted to create a template that would have our users signatures be at the bottom of the email when the Outlook stub new email opened up.
That also was a dead end, no one seems to have found a way to make that happen either.
Is the add-on manager available in Excel?
Try adding it that way.
Totally missed where the save as was
Excel button
Save as
Choose “Other formats” at the bottom
Select Excel add-in from the drop down selection box
Thanks to Rick for making me go back a revisit this issue.