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

"Sandy" wrote in message
...
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" wrote in message
...
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