Thnak you (both of you), I thought about put the value in a cell but is more
interesting how to save it into another file (.ini), could some of you tell
me an example how to save the value in a file???

sub SaveTheValueOfAVariable()
dim a as string
a=cell(1,b)
'Here I want to save a so the next time excel is open a has his value
end sub
Tanks you very much
"Peter T" wrote:

Some possibilities-

If you only need the variable/value in a particular workbook -
A Defined name's refersto
some cell

Or for anything -
as above but in -
Personal.xls (save before you're asked to)
An addin (you won't get asked so save it)
some other workbook (perhaps in XLStart)

ini or text file
registry

Regards,
Peter T

"filo666" wrote in message
...
Hi, There is somehow a variable rememver his value allthought excel is
closed???
TKS