/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 vote169 views1 answer
Vba line feed
VBA
0 vote178 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote165 views1 answer
VB get external IP address
VBA
3 votes172 views1 answer
Vba make long from two shorts
VBA
4 votes180 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote194 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote186 views1 answer
Vba search string position
VBA
0 vote169 views1 answer
Vba pass named range to function
VBA
0 vote175 views1 answer
Putting marquee in vb.net
VBA
5 votes188 views1 answer
Vba low byte from INTEGER
VBA