variable that keeps its value until reset  
Author Message
JohnViall





PostPosted: 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





PostPosted: 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





PostPosted: 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
>>
>>
>
>
>.
>