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