/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 vote113 views1 answer
Vba listindex select multiple items vba
VBA
5 votes159 views1 answer
Excel vba left word from Long Integer
VBA
0 vote157 views1 answer
Move bindingnavigator vb
VBA
0 vote147 views1 answer
Vba like with wildcard
VBA
1 vote161 views1 answer
Excel vba array remove first
VBA
8 votes151 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote140 views1 answer
Vba line feed
VBA
1 vote159 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
11 votes298 views1 answer
Excel vba How to URL encode a string
VBA
0 vote143 views1 answer
Vba test optional argument
VBA