Check if library exists

[response]

Hi, I need help. How to check if library exists? I have library name and I would check if library exists. If library doesn't exists then macro should this library turn on.

[snb]

simply use createobject("libraryname")

If it's loaded it wil be used

If it's not loaded it will be loaded and used.

[response]

Thanks snb. Doesn't work Show me "ActiveX component can't create object". How to fix? I should give the path to library or only library name?

[snb]

library name

[response]

Uhm, doesn't work.

I receive error "ActiveX component can't create object".

My code

CreateObject ("Microsoft ActiveX Data Objects 2.8 Library")

[snb]

With CreateObject("ADODB.recordset")

[response]

Thanks, and how to enabled "Microsoft Visual Basic for Applications Extensibility 5.3" library?

[snb]

see: http://www.snb-vba.eu/VBA_Excel_VBproject_en.html

[response]

Wow, snb You're the best! Thanks You very much!