I use registry settings:
'======
Sub GetRegistrySetting()
'Begin Registry setting
'"appname:=" = Desired name you create, variable or "string", preferred
a "string"
'"section:=" = Desired name you create, variable or "string"
'"Key:=" = Desired name you create, variable or "string"
'Notes: Variables do not use quotes, strings use quotes
SomeVariable = GetSetting(appname:="AppNameHere",
section:="SectionNameHere", _
Key:="KeyNameHere")
'End registry setting
End Sub

Sub SetRegistrySetting()
'Begin Registry setting
'"appname:=" = Desired name you create, variable or string, preferred a
string
'"section:=" = Desired name you create, variable or string
'"Key:=" = Desired name you create, variable or string
'setting:=" = variable or string
SaveSetting appname:="AppNameHere", section:="SectionNameHere", _
Key:="KeyNameHere", setting:="SettingValueHere"
'End registry setting
End Sub
'======
--
Regards

VBA.Noob.Confused
XP Pro
Office 2007



"filo666" wrote:

Hi, There is somehow a variable rememver his value allthought excel is
closed???
TKS