GETALLSETTINGS

GETALLSETTINGS(appname, section)

Returns the list of key settings and their values from the registry (Variant).


appnameThe name of the application or project (String).
sectionThe name of the section (String).

REMARKS
* This function can be used to read registry settings from the following registry path: HKEY_CURRENT_USER\Software\VB and VBA Program Settings\
* The "appname" is the subkey below the "VB and VBA Program Settings" key.
* The "section" is the subkey of the key specified in the "appname" argument.
* This function returns an uninitialized Variant (Empty) if either appname or section does not exist.
* This function returns Empty if there are no keys below the subkey.
* The returned value is a 2-dimensional array containing keys and values.
* The "appname" on the Macintosh is the filename of the initialisation file in the preference folder in the system folder.
* For more information, refer to the Macros > Registry page.
* The equivalent .NET function is Microsoft.VisualBasic.Interaction.GetAllSettings
* For the Microsoft documentation refer to learn.microsoft.com

Dim vReturned As Variant 
vReturned = GetAllSettings("MyApp","MySection")
Msgbox vReturned(0,0) = "MyKey"
Msgbox vReturned(0,1) = "MySettingValue"

vReturned = GetAllSettings("My Amazing Add-in","User Settings")
Msgbox vReturned(0,0) = "Full Name"
Msgbox vReturned(0,1) = "David Smith"

vReturned = GetAllSettings("My Amazing Add-in","Does Not Exist")
Msgbox vReturned = Empty

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top