|
每次打开EXCEL的时候总得重新引用一下,正则表达式与字典,无法一次引用之后,就一直有效,不知这是什么情况,如何解决?非常感谢!!
自动检测加载代码 - Private Sub Workbook_Open()
- '信任对VBA工程的访问
- Dim WshSHell
- Set WshSHell = CreateObject("WScript.Shell")
- WshSHell.RegWrite "HKEY_CURRENT_USER\Software\Microsoft\Office" & Application.Version & "\Excel\Security\AccessVBOM", 1, "REG_DWORD"
-
- If Not CheckReference("Scripting") Then
- 'Microsoft Scripting Runtime
- If Application.VBE.ActiveVBProject.References.AddFromGuid("{420B2830-E718-11CF-893D-00A0C9054228}", 1, 0) Is Nothing Then
- Debug.Print "Microsoft Scripting Runtime error"
- End If
- End If
-
- If Not CheckReference("VBScript_RegExp_55") Then
- 'VBScript_RegExp_55
- If Application.VBE.ActiveVBProject.References.AddFromGuid("{3F4DACA7-160D-11D2-A8E9-00104B365C9F}", 5, 5) Is Nothing Then
- Debug.Print "VBScript_RegExp_55 error"
- End If
- End If
-
- If Not CheckReference("VBIDE") Then
- 'VBIDE
- If Application.VBE.ActiveVBProject.References.AddFromGuid("{0002E157-0000-0000-C000-000000000046}", 5, 3) Is Nothing Then
- Debug.Print "VBIDE error"
- End If
- End If
- End Sub
- Function CheckReference(ByVal refname As String) As Boolean
- Dim ref
- For Each ref In ThisWorkbook.VBProject.References
- If UCase(ref.Name) Like UCase(refname) Then
- CheckReference = True
- Exit Function
- End If
- Next
- End Function
复制代码
|
|