View Single Post
  #3   Report Post  
Old February 18th 20, 01:37 PM posted to microsoft.public.excel.programming
Terry Pinnell[_4_] Terry Pinnell[_4_] is offline
external usenet poster
First recorded activity by ExcelBanter: Aug 2015
Posts: 192
Default Using registry for data storage and transfer?

"Peter T" wrote:

"Terry Pinnell" wrote in message
I've just come across the SaveSetting and GetSetting VBA functions to
save and recover data from the registry. MX Pro also has similar
commands. So would this be a viable and possibly superior alternative

Form most purposes in VBA SaveSetting, GetSetting and DeleteSetting are a
very viable alternative to using the various registry APIs.

They might be considered superior in the sense of very simple and no risk
using the APIs incorrectly. Less superior in the sense you are restricted to
this path in the registry:
HKEY_CURRENT_USER\Software\VB and VBA Program Settings\

Peter T

Thanks Peter, understood. That restriction doesn't worry me. I already
use one other 'fenced' key for working with Macro Express Pro. Once it's
in the Regedit Favourites it's easy to find, and means I'm unlikely to
cause widespread damage!

I'll aim to try a small project.