/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 vote256 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote242 views1 answer
Vba count all row
VBA
1 vote248 views2 answers
Vba string length
VBA
1 vote236 views1 answer
Vba date to unix timestamp
VBA
0 vote186 views1 answer
Vbide vbproject reference
VBA
0 vote281 views1 answer
Wpf dark title bar
VBA
0 vote228 views1 answer
Add items to combobox vb.net
VBA
3 votes226 views1 answer
Excel vba get the workbook full file name with path
VBA
0 vote229 views1 answer
Excel vba select multiple shapes
VBA
2 votes241 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA