Variables- How do I keep a Variable from being reset when closing excel
Thanks Dave, but I would like to avoid saving it to a
different workbook. Ideally I would like to save it to
the registry but I do not know how. Is there sample code
out there for saving variable to the registry?
Thanks Again
Quote:
>-----Original Message-----
>the most straight formward method is to save it on
>aworksheet, if that isn't acceptable you can save it to
>the registry, create another file (excle or text) and
save
>it there, choice depends on your skill and whether the
>varaible needs to attributed to the user/machine or the
>spreadsheet. If its the spreadsheet, then perhpas best to
>save to a worksheet so that it is avaiable when user # 2
>opens the file
>dave
>>-----Original Message-----
>>I would like to be able to keep the value of a variable
>>although I close excel. I do not want my variable to be
>>reset when I close out of excel.
>>Thanks
>>.
>.
