Read/write registry values in VBA

[CedarTree]

Anyone have code that can read/write registry values, including (importantly) Hex/Binary values? THANKS!

 

[theDBguy]

Hi. Not sure if this will work for you, but take a look at SaveSetting and GetSetting functions.

SaveSetting statement (VBA)

Office VBA reference topic

docs.microsoft.com

GetSetting function (Visual Basic for Applications)

Office VBA reference topic

docs.microsoft.com

 

[CedarTree]

I don't think this does the trick, but thanks - most of the examples I found online use Windows scripting. But few address the Binary issue.

 

[theDBguy]

I don't think this does the trick, but thanks - most of the examples I found online use Windows scripting. But few address the Binary issue.

Oh, okay. Good luck!

 

[Isaac]

I don't think this does the trick, but thanks - most of the examples I found online use Windows scripting

And why don't you want to use Windows scripting?

 

[The_Doc_Man]

Read and Write Binary Registry Keys

Help, MSDN is arguing with itself again. This page claims that there is no way to read or modify binary keys, only strings and numbers. (these functions use Windows API calls) http://support.microsoft.com/kb/145679 However, this article suggests that you can use the StdRegProv class of...

www.vbaexpress.com

I'll echo Isaac's question. What's wrong with using Windows Scripting? If you look at the thread, it adds at most 2 lines of code to whatever module is involved.

 

[isladogs]

Attached is a .bas file which contains code needed to read/write to the registry.
Unzip and import as a standard module.
Note that whilst you can edit the HKCU hive without any problems, you need elevated permissions to edit the HKLM hive.
This is for security reasons. Run your Access app as an administrator if you want to edit the HKLM hive

Hope that helps

 

[CedarTree]

Sorry I wasn't clear. I wasn't against WS. I didn't think theDBguy's example was even using that.

 

[isladogs]

Re post #2:
Forgot to say earlier, SaveSetting/GetSetting/DeleteSetting can only be used with one specific registry location:
HKEY_CURRENT_USER\Software\VB and VBA Program Settings.

 

[CedarTree]

Thanks. I'm going with the route of using Cmd prompt via VBA... that might do the trick and have less limitations, and allow me to change Binary values.

 

[CedarTree]

The coding above, for example, is good coding, but doesn't handle Binary. But thanks!!!

 

[isladogs]

Ah sorry. I forgot to check that part was included. I have that code somewhere else.
No time to look tonight but will have a search tomorrow if I have time.

 

[CedarTree]

Thanks! Let me know please if you find that.