List the keys and values saved in the registry (VBA).
Syntax GetAllSettings appname:="AppName", Section:="Section" GetAllSettings"AppName", "Section" Key AppName The name of the application or project.
Section The name of the section where the keys are saved.
All the registry entries will appear under HKEY_CURRENT_USER\Software\VB and VBA Program Settings\
If either of the arguments do not exist in the registry then GetAllSettings will return an uninitialised variant.
Retrieve all the settings stored under the section named "DemoDB":
Dim MySettings as Variant, intSettings as Integer MySettings = GetAllSettings("SS64", "DemoDB") For intSettings = LBound(MySettings, 1) To UBound(MySettings, 1) Debug.Print MySettings, 0), MySettings(intSettings, 1) Next intSettings
“The act of bell ringing is symbolic of all proselytizing religions. It implies the pointless interference with the quiet of other people” ~ Ezra Pound
DeleteSetting - Delete a value from the users registry
GetSetting - Retrieve a value from the users registry
SaveSetting - Store a value in the users registry