I have written a VBA function in a module. Now I want to save that workbook
as add-in. But when I try saving it, I cannot see any ".xla" dropdown in
"Save as type".

If I save it forcefully as ".xla" and try to install as add-in to another
workbook, excel says, invalid add-in.

What do I do?

In Excel 2003, the add-in option is the very last one on the dropdown list for filetype (unless you
have the 2007 file conversion utility installed).

HTH,
Bernie
MS Excel MVP


"Parag" wrote in message
...
I have written a VBA function in a module. Now I want to save that workbook
as add-in. But when I try saving it, I cannot see any ".xla" dropdown in
"Save as type".

If I save it forcefully as ".xla" and try to install as add-in to another
workbook, excel says, invalid add-in.

What do I do?

What version of Excel are you using? I've never seen the behavior you
describe. If you can't save the workbook as an add-in in the normal
manner, try the following. Open the VBA Editor (ALT F11), then open
the Immediate window (CTRL G). In the Immediate window, enter each of
the lines below, pressing ENTER after each line. Change the file name
to the appropriate nameL.

ThisWorkbook.Save
ThisWorkbook.IsAddIn = True
ThisWorkbook.SaveAs "C:\Test\YourAddInName.xla"

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Tue, 27 Jan 2009 05:28:01 -0800, Parag
wrote:

I have written a VBA function in a module. Now I want to save that workbook
as add-in. But when I try saving it, I cannot see any ".xla" dropdown in
"Save as type".

If I save it forcefully as ".xla" and try to install as add-in to another
workbook, excel says, invalid add-in.

What do I do?

Hi Chip,

Thanks for your reply ! Your code works ! I could save and use that add-in
with your code. But I wonder why I could not save it the usual way. I use
Excel 2000.

By the way, what is immediate? Also as I'm new to VBA, can you suggest me
some good online learning materail.

Thanks!

"Chip Pearson" wrote:

What version of Excel are you using? I've never seen the behavior you
describe. If you can't save the workbook as an add-in in the normal
manner, try the following. Open the VBA Editor (ALT F11), then open
the Immediate window (CTRL G). In the Immediate window, enter each of
the lines below, pressing ENTER after each line. Change the file name
to the appropriate nameL.

ThisWorkbook.Save
ThisWorkbook.IsAddIn = True
ThisWorkbook.SaveAs "C:\Test\YourAddInName.xla"

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Tue, 27 Jan 2009 05:28:01 -0800, Parag
wrote:

I have written a VBA function in a module. Now I want to save that workbook
as add-in. But when I try saving it, I cannot see any ".xla" dropdown in
"Save as type".

If I save it forcefully as ".xla" and try to install as add-in to another
workbook, excel says, invalid add-in.

What do I do?