Thread: Late Binding
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Late Binding

If you may or may not be able to use Early Binding why not be done with it
and use Late Binding. Change related object declarations to "As Object' and
use CreateObject.

For developing, set the references and revert to Early Binding methods to
get the intellisense, and re-adapt to Late Binding when done.

Regards,
Peter T


"atpgroups" wrote in message
...
I have a project which links to either of two other packages.
Depending on which package is being used the alternative package will
not be installed and/or will not be selected in the VBA "References"
list.

I have created wrapper classes to selectively act on objects of
classes from each of the other applications but I am still having
problems with "User defined type not defined"

The problem arises any time I try to Dim a variable as a type defined
by one of the external applications even if the code will never run
through that area (Of course the compiler/parser has no way of knowing
that)

Is there any way to have conditional Dim-ing? Should I instead be
declaring as objects and then creating using CreateObject rather than
"Dim O as New clsRandomObjectWhichMightNotExist"

Any pointers or guidelines?