Store variables between XLA sessions

  • Thread starter Thread starter Timo Autiokari
  • Start date Start date
T

Timo Autiokari

Hi,

could you please tell me if it is possible to save parameters into th
XLA add-in itself, by a macro that is in that XLA?

What I'm looking for is to store some preference settings in such wa
that they are there the next time Exel and the XLA is opened and als
that they move with the XLA when the add-in is copied to anothe
machine.

I know how to write variables to a disk file but I would not want t
use that.

Thank you,
Tim
 
Hi Timo,
could you please tell me if it is possible to save parameters into the
XLA add-in itself, by a macro that is in that XLA?

What I'm looking for is to store some preference settings in such way
that they are there the next time Exel and the XLA is opened and also
that they move with the XLA when the add-in is copied to another
machine.
Click to expand...

An addin can have worksheets, just as any normal workbook. So you can
write your values to worksheet cells inside the addin, then save the
addin. IN a later session you can retrieve those settings.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Jan,

thank you very much! I've never realized that they are still there.

It seems that one can not anymore actually see the worksheet (like i
is seen in XLS) after saving the workbook as XLA so adding names et
must all be done using code.

Addressing the names on the worksheet in an XLA seem not the same (a
with XLS), I need to add the sheet name lik
myStore=ThisWorkbook.Sheets("Sheet1") .myStore.Value

BR,
Tim
 
Back
Top