Posted to microsoft.public.excel.programming
|
|
Compile Errors and Missing references
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
|