Persistent Storage for Add-Ins ?

[Brian Herbert Withun]

I have created a .XLA excel add-in and everything is going fine.

In the VBA Project I can see the Module and the Workbook that comprise
the XLA when I look at the Project heirarcy. I also see a worksheet
represented there in the hierarchy. I can't imagine why the XLA has
*any* sheets associated with it, and I can't seem to access that sheet
in any way.

Does anyone know why it's listed there as part of the XLA, and what
purpose it has?

Can I use this sheet to store values that will persist across
sessions? I'm thinking I might be able to store my add-in licensing
information there, but again, I can't seem to access anything on, in,
or from that Worksheet (Sheet1).

Kind Regards,

Brian Herbert Withun

 

[Bernie Deitrick]

Brian,

A workbook is defined as a file containing at least one worksheet - that is eaht Exel is. Anyway,
it is very common to use the worksheet to store information.

Simply use code like

ThisWorkbook.Worksheets("Sheet1").Range("A1").Value = "Value I want to store"


You could also change the codename of the worksheet and shorten that to

SheetCodeName.Range(".....


HTH,
Bernie
MS Excel MVP

 

[Peter T]

Hi Brian,

Worksheets in addin can serve all sorts of useful purposes, such as storing
data or settings for use with your own project, or temporarily within the
current session.

I can't seem to access anything on, in,
or from that Worksheet (Sheet1).

set ws = Thisworkbook.Worksheets("Sheet1")

Can I use this sheet to store values that will persist across
sessions?

Yes but subject to being able to save, which you won't be able to do if the
your addin is open in multiple instances, eg

If not Thisworkbook.Readonly then
thisworkbook.save
else
?
end if

Regards,
Peter T