Home |
Search |
Today's Posts |
#11
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable sheet reference check | Excel Worksheet Functions | |||
Check-box relative reference | Excel Discussion (Misc queries) | |||
Check Box reference name | Excel Discussion (Misc queries) | |||
Reference & update destin. cells on 1st machine from source workbook on 2nd machine. | Excel Discussion (Misc queries) |