1

I have my VBA code ready to have others test, and i was going to give it to them as an Add-in (.xla). I had tested this with some other code, to make sure i could do it, and was able to create an .xla file.

Now, for my current code i cannot create an .xla file. The option does not show up in the SaveAs dialog. I am using Excel 2007. Is there something i'm missing?

Any help is greatly appreciated!

thanks,

Russ

6
  • 1
    If you are using Excel 2007, you should probably be using .xlam instead of the older .xla.
    – Stewbob
    Apr 8, 2013 at 15:06
  • I'd be willing to try that, which format name is that? Is that in the SaveAs dialog? How was i able to save the previous code as an .xla?
    – Russ Urquhart
    Apr 8, 2013 at 15:12
  • You probably should be using XLAM extension. Both XLAM and XLA are available in Excel 2010. I don't have a version of 2007 to test, but I'd be surprised if both options are not available in 2007 -- can you post a screenshot? Apr 8, 2013 at 15:29
  • 1
    Ok, found the answer. When i was trying to saveas an xla, i had the chart tab open. When i went to the worksheet tab, Add-in then became the option.
    – Russ Urquhart
    Apr 8, 2013 at 15:30
  • You should post your comment as an answer! I was trying to solve your problem and hit the same issue !
    – grahamj42
    Apr 8, 2013 at 15:34

2 Answers 2

2

I found the answer the question. I had had a chart sheet open when i tried to do the SaveAs to an Add-In (.xla) file type. When the Chart Sheet tab was open, Add-in was not an option for the SaveAs. When i went to the worksheet tab, Add-In appeared again, as an option. fyi,

Russ

1

Here are the steps:

  • Start with a blank document and type/import your code

Developer

  • Select Save as Other Formats

Office Orb

  • Pick Excel Add-in, or Excel 97-2003 Addin from the list (way down).

Save As

You must log in to answer this question.