Microsoft Office Tutorials and References
In Depth Information
Windows API Calls
An easier way to access the Registry
If you want to use the Windows Registry to store and retrieve settings for your Excel
applications, you don’t have to bother with the Windows API calls. Rather, you can use VBA’s
GetSetting and SaveSetting functions.
These two functions are described in the Help system, so I won’t cover the details here.
However, it’s important to understand that these functions work only with the following key
HKEY_CURRENT_USER\Software\VB and VBA Program Settings
In other words, you can’t use these functions to access any key in the registry. Rather, these
functions are most useful for storing information about your Excel application that you need to
maintain between sessions.