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

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=27309