/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 vote350 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote419 views1 answer
Vba search string position
VBA
4 votes380 views2 answers
Vba last row
VBA
0 vote354 views1 answer
Quit excel with save changes dialog vb.net
VBA
1 vote385 views1 answer
How to put a gridpain in a vbox
VBA
1 vote375 views1 answer
Vba loop through files in folder
VBA
0 vote406 views1 answer
Move bindingnavigator vb
VBA
0 vote350 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote380 views1 answer
Vba multiple optional arguments
VBA
0 vote381 views2 answers
Delete all controls from list of control vb.net
VBA