How do I save as XLAM Excel add-in

1,050 pts.
Tags:
Add-in
Excel 2007
Visual Basic
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
ASKED: February 26, 2010  8:41 PM
UPDATED: May 8, 2013  3:52 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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…).

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Rickerssj
    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
    10 pointsBadges:
    report
  • swinehart6803
    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.
    1,050 pointsBadges:
    report
  • Chippy088
    Is the add-on manager available in Excel? Try adding it that way.
    4,625 pointsBadges:
    report
  • swinehart6803
    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.
    1,050 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following