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 |
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 |
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 |
All times are GMT +1. The time now is 12:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com