KHP
KHP
Programming language:VBA
2021-03-28 05:34:09
0
Q:

excel vba write to the windows registry

user26486
user26486
Code: VBA
2021-03-13 21:42:12 
'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!
3
DWin
DWin
Code: VBA
2021-09-08 05:33:03 
'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!
2

Tags

Related

New to Communities?

Join the community