/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 vote357 views1 answer
Switch pictures with buttons vb.net
VBA
5 votes363 views1 answer
Xl vba double quotes in string literal
VBA
0 vote335 views1 answer
How to carry text to the next line in a label in vb.net
VBA
1 vote437 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
3 votes379 views1 answer
Vba make long from two words
VBA
0 vote384 views1 answer
Excel vba DisplayAlerts
VBA
1 vote350 views1 answer
Vba reverse string
VBA
0 vote343 views1 answer
Vba verticalalignment
VBA
1 vote338 views1 answer
If inputbox cancel vba
VBA
0 vote384 views1 answer
Priavte sub with multiple handels find sneder
VBA