SaveSetting

Store a value to the users registry (VBA).

Syntax
     SaveSetting appname:="AppName", Section:="Section", Key:="Key", setting:="Setting"

     SaveSetting "AppName", "Section", "Key", "Setting"
      
Key
   AppName  The name of the application or project.

Section The name of the section in which the key setting is being saved.
Key The name of the key setting being saved.
Setting The value to which Key is being set (string or number).

All the registry entries will appear under HKEY_CURRENT_USER\Software\VB and VBA Program Settings\

Examples

Save a registry key named "LastOrderViewed" with a value of "1375", placing it under the key named "SS64", and a sub key named "DemoDB" (create the keys if they don't already exist):

SaveSetting appname:="SS64", Section:="DemoDB", Key:="LastOrderViewed", setting:=1375

“If you stuff yourself full of poems, essays, plays, stories, novels, films, comic strips, magazines, music, you automatically explode every morning like old faithful. I have never had a dry spell in my life, mainly because I feed myself well, to the point of bursting. I wake early and hear my morning voices leaping around in my head like jumping beans. I get out of bed to trap them before they escape” ~ Ray Bradbury

Related

DeleteSetting - Delete a value from the users registry
GetSetting - Retrieve a value from the users registry
GetAllSettings - List the keys and values saved in the registry


 
Copyright © 1999-2024 SS64.com
Some rights reserved