M
mangesh_yadav
Hi,
I have this excel application which gives compile error (Compile erro
in hidden module) on some user's machine. I want to verify that th
error is due to a missing reference, but I cannot ask the user to chec
his references.
What I would like to do is while opening the excel file, check all th
active references, for which I used the following code:
Sub check_references()
Dim rVBReference As VBIDE.Reference
Set wbBook = ThisWorkbook
With wbBook
'Iterate through the collection of active external references i
the VB-project.
For Each rVBReference In .VBProject.References
Debug.print rVBReference.Name
Next rVBReference
End With
End Sub
My problem is:
1. I either get "Method VBProject of object workbook failed", or
2. "cannot trust programmatical access to VBProject"
Any solutions....
Manges
I have this excel application which gives compile error (Compile erro
in hidden module) on some user's machine. I want to verify that th
error is due to a missing reference, but I cannot ask the user to chec
his references.
What I would like to do is while opening the excel file, check all th
active references, for which I used the following code:
Sub check_references()
Dim rVBReference As VBIDE.Reference
Set wbBook = ThisWorkbook
With wbBook
'Iterate through the collection of active external references i
the VB-project.
For Each rVBReference In .VBProject.References
Debug.print rVBReference.Name
Next rVBReference
End With
End Sub
My problem is:
1. I either get "Method VBProject of object workbook failed", or
2. "cannot trust programmatical access to VBProject"
Any solutions....
Manges