Variable that retains value after closing excel

Is it possible to force a variable to retain its value after closing excel.
In other words when excel is opened next time the value of the variable at
close is retained?
Sandy

One way is to store in a cell somewhere

--
Don Guillett
SalesAid Software
donaldb@281.com
"Sandy" <sandy_stephen@DELETEhotmail.com> wrote in message
news:ONItq937FHA.476@TK2MSFTNGP15.phx.gbl...
> Is it possible to force a variable to retain its value after closing
> excel. In other words when excel is opened next time the value of the
> variable at close is retained?
> Sandy
>

Hi Sandy,

Amongst a number of possibilities, you could write the variable's value to a
defined name in the Workbook_BeforeClose procedure and read it in the
Workbook_Open event; alternatively, you could write the value to a (hidden?)
sheet. Other possibilites would include wtiting the value to the registry or
a Workbook property.


---
Regards,
Norman



"Sandy" <sandy_stephen@DELETEhotmail.com> wrote in message
news:ONItq937FHA.476@TK2MSFTNGP15.phx.gbl...
> Is it possible to force a variable to retain its value after closing
> excel. In other words when excel is opened next time the value of the
> variable at close is retained?
> Sandy
>