/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

22 votes557 views1 answer
Xl vba check for folder
VBA
0 vote250 views1 answer
Vba string
VBA
0 vote232 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote178 views1 answer
Excel autofilter vba
VBA
-1 vote229 views1 answer
For i in range vba
VBA
0 vote229 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote245 views1 answer
Vba simple quote
VBA
3 votes262 views1 answer
Excel vba get the workbook full filename with path
VBA
4 votes230 views2 answers
Vba array length
VBA
5 votes238 views1 answer
Xl vba double quotes in string literal
VBA