|
|
variable that keeps its value until reset |
|
Author |
Message |
JohnViall
|
Posted: Mon Sep 29 21:25:04 CDT 2003 |
Top |
Excel Programming >> variable that keeps its value until reset
Hi,
How can I declare a variable that will keep its value not only after a
procedure is run, but when Excel or the computer is shut down--that will
keep its value until it is reset?
THanks,
Jamie
Excel393
|
|
|
|
|
Robin
|
Posted: Mon Sep 29 21:25:04 CDT 2003 |
Top |
Excel Programming >> variable that keeps its value until reset
Jamie,
You would have to store it in the registry or write it to a text file.
Have a look at help on SaveSetting and GetSetting.
Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in
> Hi,
>
> How can I declare a variable that will keep its value not only after a
> procedure is run, but when Excel or the computer is shut down--that will
> keep its value until it is reset?
>
> THanks,
>
> Jamie
>
>
|
|
|
|
|
bruce
|
Posted: Mon Sep 29 23:57:10 CDT 2003 |
Top |
Excel Programming >> variable that keeps its value until reset
The place you might be thinking of storing your variable
might be within your VBA code. This can be done and it
might best be stored in a little two line routine that can
be called as required.
Self modifying code is possible but you will have to
search the internet or MS Knowledgebase for a good lead.
>-----Original Message-----
>Jamie,
>
>You would have to store it in the registry or write it to
a text file.
>
>Have a look at help on SaveSetting and GetSetting.
>
>Robin Hammond
>www.enhanceddatasystems.com
>Check out our XspandXL add-in
>
>
>> Hi,
>>
>> How can I declare a variable that will keep its value
not only after a
>> procedure is run, but when Excel or the computer is
shut down--that will
>> keep its value until it is reset?
>>
>> THanks,
>>
>> Jamie
>>
>>
>
>
>.
>
|
|
|
|
|
|
|