/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 vote364 views1 answer
Visual basic run command
VBA
0 vote297 views1 answer
Vba pass named range to function
VBA
5 votes357 views1 answer
Excel vba low word from Long Integer
VBA
0 vote309 views1 answer
Get current url vb.net
VBA
22 votes471 views1 answer
Xlvba check for folder
VBA
0 vote320 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote313 views1 answer
Vbscript check if string is empty
VBA
1 vote309 views1 answer
Excel date to unix timestamp
VBA
3 votes343 views2 answers
Vba date to string
VBA
0 vote272 views1 answer
Vba set vs dim
VBA