Thanks Ryan for the additional links////

If this post helps click Yes
---------------
Jacob Skaria


"ryguy7272" wrote:

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/E...ateBinding.htm

Good luck,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Tom Joseph" wrote:

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.