registering dll

[k2sarah]

I distribute an excel application w/ references to word and ppt. Recently got
upgraded in excel 2003. some users still have excel 2000. during upgrade, i
could not longer locate reference to 9 OBJECT LIBRARYies of word and ppt. I
had a friend email me the olb files, and placed them in appropriate
directory. I then added the references. When i run the macro, i get a compile
error: Error in loading dll. what can i do? how do i register this dll?

thks

 

[Cindy Meister]

Not knowing which DLL, there's no way to answer this.

Generally, a VBA application should automatically reference the installed
version's object libraries. Office 2000 was a bit "broken" in this respect,
however.

A VBA project shouldn't care whether it references a version 9, 10 or 11
dll. Someone should be able to open the VBA project in Excel, go to
Tools/References and reactivate any MISSING references to the version
installed on the machine. Problems can only crop up when the code in one
version differs from that in another. Theoretically, this shouldn't happen.
But the MS developers aren't perfect (any more than anyone else) and there
are a few commands that can conflict.

As a general rule, it's important to test an application in each version of
Office in which it will be used.