View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default How to test if a DLL (library) exists

How do I test in VBA to see if a particual DLL exists in my references? I
want to test to see if the RegExp library exists and if so I want to check it
off. If it does not exist I want o generate an error message prompting the
user that the file is not available in the libraries.

On a side note, I am assuming that the library should be available. Why
would it not be? Is there any reason that xl97 upward would not have this?
And if it is not available, what are the users options (assuming this may be
driven by version of Excel). For example, say the user had it but
accidentally deleted it. What would they need to do to restore it?

Thanks