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
>