Persistent Storage for Add-Ins ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian Herbert Withun - 25 Jan 2008 14:06 GMT

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

Reply to this Message

Bernie Deitrick - 25 Jan 2008 14:19 GMT

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

>I have created a .XLA excel add-in and everything is going fine.
>
[quoted text clipped - 15 lines]
>
> Brian Herbert Withun

Reply to this Message

Peter T - 25 Jan 2008 14:24 GMT

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

> I have created a .XLA excel add-in and everything is going fine.
>
[quoted text clipped - 15 lines]
>
> Brian Herbert Withun

Reply to this Message