/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

2 votes132 views1 answer
Vba round number
VBA
0 vote123 views1 answer
Open application from vbnet
VBA
0 vote124 views1 answer
Vba text to general
VBA
-1 vote135 views1 answer
How to correct a number to 2 decimal places in vba
VBA
8 votes122 views1 answer
Excel vba make a short integer from two bytes
VBA
3 votes138 views1 answer
Excel vba change format of cell
VBA
1 vote136 views1 answer
Set font for ms chart vb.net
VBA
0 vote138 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote180 views2 answers
Excel vba store array and write to sheet
VBA
5 votes146 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA