Solved: MsgBox to list missing .references

[JimS]

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]

can i see the code?

[VBA]On Error Goto ErrHandler:
'CODE
Exit Sub

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

[CatDaddy]

http://vbadud.blogspot.com/2008/04/g...a-project.html

maybe is what you are looking for?

[JimS]

Excellent, just what I needed.

Thanks...

JimS