I would like to add a trusted location key to the registry using vba.
I am using the following vba code to determine if the registry key already exists:
If RegKeyExists("HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\BEApplication\") = False Then
' Code for adding registry key
Else
' Key exists - do nothing
End If
Function RegKeyExists(i_RegKey As String) As Boolean
Dim myWS As Object
On Error GoTo ErrorHandler
'access Windows scripting
Set myWS = CreateObject("WScript.Shell")
'try to read the registry key
myWS.RegRead i_RegKey
'key was found
RegKeyExists = True
Exit Function
ErrorHandler:
'key was not found
RegKeyExists = False
End Function
The above code works, returning True if the registry key exists and False if it does not.
I have created a .reg file for adding the registry key. The contents of the .reg file are as follows:
Sub RegKeySave(i_RegKey As String, _ i_Value As String, _ Optional i_Type As String = "REG_DWORD")Dim myWS As Object 'access Windows scripting Set myWS = CreateObject("WScript.Shell") 'write registry key myWS.RegWrite i_RegKey, i_Value, i_TypeEnd Sub
http://slipstick.com/developer/read-and-change-a-registry-key-using-vba/
see function "RegKeySave":
Open in new window