/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 vote168 views1 answer
Vb check if row has column
VBA
31 votes319 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote184 views1 answer
Find database connection string vb
VBA
1 vote183 views1 answer
Add rows to datagridview vb.net
VBA
0 vote197 views1 answer
Excel vba protect scenarios
VBA
0 vote181 views1 answer
Arq linux
VBA
-1 vote164 views2 answers
How close excel through visual basic
VBA
4 votes183 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
2 votes182 views1 answer
Excel vba check if string entirely alpha
VBA
15 votes320 views2 answers
Xl vba dynamic string array
VBA