/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

1 vote241 views1 answer
Extract the second word in a text in excel
VBA
1 vote229 views2 answers
Vba find last row in range for certain criteria
VBA
6 votes255 views1 answer
Excel vba isalpha
VBA
0 vote231 views1 answer
Switch pictures with buttons vb.net
VBA
3 votes247 views1 answer
Excel insert blank row for value change in column
VBA
20 votes521 views1 answer
Excel vba recursive example factorial function
VBA
0 vote224 views1 answer
Vba get text file content
VBA
0 vote248 views1 answer
Excel vba protect scenarios
VBA
0 vote347 views2 answers
VB
VBA
0 vote233 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA