Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Persistent Storage for Add-Ins ?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Persistent Storage for Add-Ins ?
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").Valu e = "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 "Brian Herbert Withun" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Persistent Storage for Add-Ins ?
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 "Brian Herbert Withun" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Persistent classes | Excel Programming | |||
Persistent Data in a Combo Box | Excel Programming | |||
Empty but persistent toolbar | Excel Programming | |||
Persistent data in an Add-in | Excel Programming | |||
Persistent Excel toolbar | Excel Programming |