/VBA/Excel vba write to the windows registry

Excel vba write to the windows registry

Excel vba read registry key value

'VBA function to READ from the Windows Registry:

Public Function RegRead(Key$) As String
    On Error Resume Next
    With CreateObject("wscript.shell")
        RegRead = .RegRead(Key)
    End With
    If Err Then Err.Clear
    On Error GoTo 0
End Function

'NB: Always backup the Windows Registry before accessing it!

Source: academy.excelhero.com

Excel vba write to the windows registry

'VBA function to WRITE to the Windows Registry:

Public Sub RegSave(Key$, valType$, Val$)
    With CreateObject("wscript.shell")
        .RegWrite Key, Val, valType
    End With
End Sub

'NB: Always backup the Windows Registry before accessing it!

Source: academy.excelhero.com

Similar codes

0 vote338 views1 answer
String contins in vba
VBA
4 votes353 views2 answers
Vba last row
VBA
0 vote355 views1 answer
How to enter Vbox manage commands
VBA
3 votes313 views1 answer
Excel vba last row in range
VBA
0 vote318 views1 answer
Do until vb.net
VBA
-1 vote324 views1 answer
For i in range vba
VBA
0 vote324 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote325 views1 answer
Change "location" of binding navigator vb
VBA
0 vote334 views1 answer
Show unix time in vba
VBA
0 vote337 views1 answer
Dynamic array vba
VBA