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

Hi
maybe use late binding. see:
http://www.xldynamic.com/source/xld.EarlyLate.html

"mangesh_yadav" wrote:


Hi,

I have this excel application which gives compile error (Compile error
in hidden module) on some user's machine. I want to verify that the
error is due to a missing reference, but I cannot ask the user to check
his references.

What I would like to do is while opening the excel file, check all the
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 in
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....

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=273090