PDA

View Full Version : Solved: MsgBox to list missing .references



JimS
07-20-2011, 12:44 PM
Is it possible to alert a user that a VBA Reference is missing?

I would like to provide the user with a MsgBox indicating that a certain VBA Reference is missing.

The reference happens to be from a 3rd party app (SalesForce.com).

Any ideas?

Thanks...

JimS

CatDaddy
07-20-2011, 12:56 PM
can i see the code?

On Error Goto ErrHandler:
'CODE
Exit Sub

ErrHandler:
missingRef = "3rd Party Application from SalesForce.com"
MsgBox ("Missing Reference: " & missingRef)
End Sub

CatDaddy
07-20-2011, 12:59 PM
http://vbadud.blogspot.com/2008/04/get-references-of-vba-project.html

maybe is what you are looking for?

JimS
07-20-2011, 02:02 PM
Excellent, just what I needed.

Thanks...

JimS