/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 vote211 views1 answer
Vba exit while
VBA
1 vote208 views1 answer
Vbscript convert ascii code to character
VBA
1 vote229 views1 answer
Excel vba array remove first
VBA
0 vote213 views1 answer
Remove frist letter from string vbnet
VBA
0 vote227 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote227 views1 answer
Vba word pdf table to excel
VBA
0 vote248 views1 answer
If statement vdhl
VBA
0 vote229 views1 answer
Excel vba clear filter
VBA
22 votes289 views1 answer
Excel vba check if directory exists
VBA
0 vote218 views1 answer
Excel vba scroll to cell
VBA