/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

6 votes159 views1 answer
Excel vba check if a string only contains alpha characters
VBA
20 votes311 views1 answer
Excel vba recursive example factorial function
VBA
12 votes292 views1 answer
Excel vba write string to text file
VBA
0 vote166 views1 answer
Discern between file and folder given path vb.net
VBA
1 vote159 views1 answer
Vba refresh pivot table
VBA
0 vote180 views1 answer
Iterate all file in a folder vba
VBA
0 vote165 views2 answers
Vb.net include quotes in string
VBA
15 votes300 views2 answers
Xl vba dynamic string array
VBA
0 vote155 views1 answer
Excel vba address not absolute
VBA
5 votes183 views1 answer
Excel vba get low byte from INTEGER
VBA