LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #11   Report Post  
Posted to microsoft.public.excel.programming
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.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable sheet reference check adimar Excel Worksheet Functions 0 February 6th 08 08:02 PM
Check-box relative reference hmm Excel Discussion (Misc queries) 1 May 6th 07 12:39 PM
Check Box reference name Kris in Kenya Excel Discussion (Misc queries) 3 March 28th 06 03:14 PM
Reference & update destin. cells on 1st machine from source workbook on 2nd machine. [email protected] Excel Discussion (Misc queries) 6 February 28th 06 05:15 AM


All times are GMT +1. The time now is 01:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"