I guess you are missing the articles by Microsoft that suggest you late
bind.
Early binding is excellent during development, but for distribution, late
binding is probably the best bet.
http://support.microsoft.com/default...b;EN-US;244167
INFO: Writing Automation Clients for Multiple Office Versions
http://support.microsoft.com/default...b;en-us;245115
INFO: Using Early Binding and Late Binding in Automation
http://support.microsoft.com/default...b;en-us;247579
INFO: Use DISPID Binding to Automate Office Applications Whenever Possible
Address some of the issues.
If Chip feels that strongly about it, maybe he will post an explanation.
Regards,
Tom Ogilvy
"Pete McCosh" wrote in message
...
All,
I'm having a few problems getting something clear in my
mind and I hope someone can help.
From my limited experience with VBA and from searching for
help on this it would seem that there's no doubt I should
be early-binding when creating new objects in my code. If
Chip Pearson says "there is never a good reason for not
using early binding", then that's good enough for me. If
necessary, I set a reference to the appropriate library
and off I go!
The problem arises when I try to get another user to
access the same application: it falls over on the
Outlook / VBscript / whatever specific references.
Obviously I can get the user to set a reference manually,
but that would seem to be an admission of defeat.
I thought I might be missing something simple: maybe the
reference is specific to the project, but a simple
experiment disproved that theory.
Every previous article I can find simply re-iterates the
same thing. Always use early-binding.
What am I missing?
Pete