/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 vote280 views1 answer
Vba code to open a file with login rights
VBA
0 vote271 views1 answer
Vba type
VBA
5 votes328 views1 answer
Xlvba double quotes in string literal
VBA
0 vote289 views1 answer
Vbnet add axis labels to chart
VBA
0 vote293 views1 answer
Find control with name vb
VBA
0 vote265 views1 answer
Excel vba hide columns
VBA
4 votes261 views1 answer
Excel formula for last non-empty cell in a column
VBA
0 vote295 views1 answer
Excel vba disable screen update
VBA
18 votes426 views3 answers
Excel-vba make integer
VBA
0 vote298 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA