Libraries in Excel
If you "check the box" and save the file and another user opens the file,
the box will still be checked. The only problem that can occur is if the
referenced library does not exist on the other user's machine. In that case
an untrappable error will occur. If that's a possibility use late binding.
Late binding does not literally "check the box" but it doesn't have to. It
does establish the reference in code.
--
Jim
"Brent" wrote in message
...
|I am trying to bystep making each user go to Tools-References on the
toolbar
| in the visual basic editor, to check the box to include the ADO 2.8
Library.
| Using early and/or late binding seems to do nothing as far as "checking
the
| box" for the user. Is there coding, since you cannot do macros for this,
to
| include the library? Like in C++ you would use the statement #include to
add
| a library, what do you have to do for either VBA or ADO?? Thank you.
|
| Brent
|