GETALLSETTINGS |
GETALLSETTINGS(appname, section) |
Returns the list of key settings and their values from the registry (Variant). |
appname | The name of the application or project (String). |
section | The 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