GetAllSettings

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.

Example

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

Related:

DeleteSetting - Delete a value from the users registry
GetSetting - Retrieve a value from the users registry
SaveSetting - Store a value in the users registry