Variable that retains value after closing excel

[Sandy]

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

[Don Guillett]

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
>

[Norman Jones]

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
>