/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

8 votes255 views1 answer
Excel vba make integer
VBA
0 vote279 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote268 views1 answer
Vba registry settings
VBA
0 vote249 views1 answer
Excel VBA web scraping
VBA
1 vote227 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote238 views1 answer
Vbs expand env var
VBA
0 vote243 views1 answer
Excel text to columns line break
VBA
-1 vote294 views1 answer
Vba sendkeys
VBA
25 votes301 views2 answers
Excel vba folder exist
VBA
0 vote271 views1 answer
Vbs run with cscript
VBA