List the keys and values saved in the registry (VBA).

      GetAllSettings appname:="AppName", Section:="Section"

      GetAllSettings"AppName", "Section"
   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

Copyright © 1999-2024
Some rights reserved