Hi there!
This code doesn't work for me. Why? I have Access 2003.
The error is "Object library not registered"
Which library?
I tried to registry all of them, some of them was fine.
But when I tried:
Regsvr32 "C:\Program Files (x86)\Microsoft Office\OFFICE11 \MSACC.OLB"
- it gives me an error: The module "C:\Program Files (x86)\Microsoft Office\OFFICE11 \MSACC.OLB" was loaded but the entry-point DllRegisterServ er was not found.
Thanks for your help!
This code doesn't work for me. Why? I have Access 2003.
Code:
Dim VBAEditor As VBIDE.VBE
Dim VBProj As VBIDE.VBProject
Dim chkRef As VBIDE.Reference
Set VBAEditor = Application.VBE
Set VBProj = VBAEditor.ActiveVBProject
For Each chkRef In VBProj.References
If chkRef.IsBroken Then
VBProj.References.Remove chkRef // Gives me an error
End If
Next
Which library?
I tried to registry all of them, some of them was fine.
But when I tried:
Regsvr32 "C:\Program Files (x86)\Microsoft Office\OFFICE11 \MSACC.OLB"
- it gives me an error: The module "C:\Program Files (x86)\Microsoft Office\OFFICE11 \MSACC.OLB" was loaded but the entry-point DllRegisterServ er was not found.
Thanks for your help!
Comment