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](http://www.excelguru.ca/node/45) 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.