Enabling libraries using VBA? Can this be done?
 

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.

Enabling libraries using VBA? Can this be done?
 

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.

Enabling libraries using VBA? Can this be done?
 

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.

Enabling libraries using VBA? Can this be done?
 

Thanks very much. Looks like that will do it.

"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.

Enabling libraries using VBA? Can this be done?
 

Thanks very much for the references.

"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.

Enabling libraries using VBA? Can this be done?
 

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.