Programmatically Save Excel Add-In

vba excel add-in excel-addins
Tom picture Tom · Dec 22, 2010 · Viewed 7.9k times · Source

I have a worksheet updated occasionally by users that is used to make an Add-In (.XLAM). The Add-In is located on a network share and users link to it. I am looking to enable users to easily update this add-in (ensuring it is marked as read only)

I have seen the article by Ken Puls here on deploying Excel Add-Ins however the .SaveCopyAs method he uses doesn’t seem to be able to accept a file type.

The .SaveAs method does, however when this was tried I gota message saying the file format or extension was invalid, I have tried both with .XLAM and .XLA as below.

DeployPath = "C:\Menu.xlam"
.SaveAs Filename:=DeployPath, ReadOnlyRecommended:=True, FileFormat:=xlOpenXMLAddIn

Any help in this regard would be greatly appreciated.

Answer

Charles Williams picture Charles Williams · Dec 22, 2010

I think that you need to use (Excel 2003 and earlier)

ThisWorkbook.IsAddin = True
ThisWorkbook.SaveAs "fredyy", xlAddIn

For Excel 2007+ use

ThisWorkbook.SaveAs "fredyy", xlOpenXMLAddIn

Related questions

Can I make Excel scroll smoothly without using middle-click?

I must work with nightmare Excel files. (I didn't create them, I just have to work with them). They were so big (more than 50 big columns and 100 big rows) then I must scroll up/down and use "<" and ">" …

Read More
onLoad ribbon callback fails (not firing/working) from Excel VBA .xlam

I've created a simple Excel add-in to demonstrate the problem whereby the ribbon onLoad event isn't firing when the project is saved and automatically loaded as a .xlam but does work when opened as a .xlsm. I've checked it for …

Read More
How can an Excel Add-In respond to events in any worksheet?

Our workbooks are server-generated SpreadsheetML, which cannot include any VBA code. Creating native Excel files or Excel 2007 XML files is also not an option, unfortunately. So, I have an Excel Add-In (VBA, not XLL) that each of our users installs …

Read More