Enabling libraries using VBA? Can this be done?

[Tom Joseph]

I am using several libraries with my VBA code including:
PDFCreator.exe
comctl32.ocx
MSOUTL.OLB

Is there a way to create the proper reference using VBA the first time the
Excel workbook is opened so that the user does not receive a "cannot find
project or library" message?

An illustration of the proper syntax would be greatly appreciated.

Thanks.

 

[Jacob Skaria]

Dear Joseph

You need to use late binding to bind the object library in code at run-time

http://www.dicks-clicks.com/excel/olBinding.htm


If this post helps click Yes

 

[ryguy7272]

Good call Jacob! Here are a few more resources for you Tom:
http://www.excelguru.ca/node/10
http://peltiertech.com/Excel/EarlyLateBinding.html
http://word.mvps.org/fAQs/InterDev/EarlyvsLateBinding.htm

Good luck,
Ryan---

 

[Tom Joseph]

Thanks very much. Looks like that will do it.

Dear Joseph

You need to use late binding to bind the object library in code at run-time

http://www.dicks-clicks.com/excel/olBinding.htm


If this post helps click Yes

 

[Tom Joseph]

Thanks very much for the references.

Good call Jacob! Here are a few more resources for you Tom:
http://www.excelguru.ca/node/10
http://peltiertech.com/Excel/EarlyLateBinding.html
http://word.mvps.org/fAQs/InterDev/EarlyvsLateBinding.htm

Good luck,
Ryan---

 

[Jacob Skaria]

Thanks Ryan for the additional links////

If this post helps click Yes