"AB" wrote in message
...

The thing to keep in mind that frankly speaking .xla and .xls aren't
that much different at all. The single biggest difference (some might
dissagree) is that tha add-ins aren't visible as Excel files in a
running Excel instance - but they all can be seen in the VBE.
But otherwise you can pretty much do the same things in either - you
can even have multiple sheets in the xla where the data are stored.
That wouldn't bee too convenient, though, as the data would be hidden
(as users can't see the xla tabs in the Excel - as per above) but the
data can be stored in the xla nevertheless.

Maybe, but holding the data in the same workbook as the code is not a good
design model, either xla or xls.