Thread: Enabling libraries using VBA? Can this be done?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default 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.
Reply With QuoteReply With Quote