/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 vote137 views1 answer
Convert unix to date vba
VBA
0 vote97 views1 answer
Vba code to remove leading and trailing spaces
VBA
2 votes135 views1 answer
Date format for ms chart vb.net
VBA
1 vote144 views1 answer
Vbs run
VBA
1 vote135 views1 answer
Vba refresh pivot table
VBA
0 vote125 views1 answer
Style percent not found vba
VBA
0 vote151 views4 answers
Vgrive,deb
VBA
0 vote133 views1 answer
Vba copy paste value only
VBA
0 vote137 views1 answer
Vbnet get file name from path
VBA
0 vote138 views1 answer
Freeze panes vba
VBA