Question : excel vba write to the windows registry
Answered by : daniel-ferry
'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 : http://academy.excelhero.com/ | Last Update : Thu, 07 May 20
Question : excel vba read registry key value
Answered by : daniel-ferry
'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 : http://academy.excelhero.com/ | Last Update : Thu, 07 May 20