VBA to instal an Addin Excel 2007

[Giordano Bruno]

I use the following code to save an "xlsm" file as an addin

With Thisworkbook
.SaveAs Application.UserLibraryPath & "ACME.xlam"

I get a run-time error 1004
This extension cannot be used with the selected file type...

If I change the file extension to .xla the file is saved as an Addin with an "xla" file extension.

I thought that 2007 required addins to have the "xlam" extension. Am I wrong?

 

[AlphaFrog]

Try something like this...

.SaveAs Application.UserLibraryPath & "ACME.xlam"[COLOR="Red"], FileFormat:=55[/COLOR]

VBA SaveAs in Excel 2007-2010

XlFileFormat Enumeration

 

[Giordano Bruno]

Thanks for the bump Montgomery, but I think you have misplaced your request.

 

[Giordano Bruno]

Thanks AlphaFrog,

I didn't notice your contribution. It takes a little while to reset the files and addin list. I'll give it a try and let you know.

 

[Giordano Bruno]

Brilliant AlphaFrog,

I fall to my knees and kiss your feet.

Problem solved.

 

[Rasm]

The Frog is good