“Company XYZ” customized one of my subroutines, and this requires a
Reference to “AdapterRDC 1.0 Type Library”. I’m guessing that they
created this library.

I’m trying to give my spreadsheet to a user who does not have this
library. They only need to run a different subroutine, which does NOT
use this library.

But they get this error.

Compile error:
Can’t find project or library

....and the VBA code that is highlighted is an ordinary Format()
function.

Why would this happen? Even as a worst case, if the extra library
were to redefine the Format() function, you’d think that when the
library is missing, VBA would be able to find Format() where it
normally finds it.

As a temporary fix, I can give each user a copy of the library’s file,
"AdapterRDC.dll". This works.

Is there some sane explanation for this and/or a better fix?

Excel 2003
Windows 2000
Other libraries referenced:
Visual Basic for Applications
Microsoft Excel 11.0 Object Library
OLE Automation
Microsoft Office 11.0 Object Library
Microsoft Forms 2.0 Object Library
Microsoft Remote Data Object 2.0
Microsoft Scripting Runtime

Dan Williams
danwPlanet