View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Check If COM Reference Available on Machine

Matthew,

I would there are compromises required here, and only you can know which
will be acceptable. If none are, you may not be able to do what you want to
do.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Matthew Wieder" wrote in message
...
I don't want to change the second workbook to late binding (due to the
development advantages of early binding). So then I'm left with
attempting to create the object via late binding in the first workbook,
which I don't want to do, because if it succeeds, I have just created th
eobject, which has overhead involved.
thanks,
-Matthew

Bob Phillips wrote:
Matthew,

I am not understanding what you mean by available then. As Jamie said,

if
you early bind, if the dll doesn't exist, CreateObject will fail, it

cannot
create an object when the dll is not there. Using late binding, the code
will compile, it will be a run-time error which is trappable.