Hi Gary,

I think this has been suggested to you previously, but why don't you
just remove this reference from your project? This reference almost
certainly belongs to a 3rd party component installed on your system. I
cannot find any suggestion that it is a component installed by any Microsoft
product.

If you attempt to unselect this reference in the Tools/References dialog
and you get an error message telling you that you can't remove it because
it's in use, it means that you are referring to this component somewhere in
your code. The alternatives at that point are to find and remove all
references to this component so that you can remove it from the
Tools/References list, or figure out what this component is and install it
on all the machines that will be running your application.

The error on the Trim function is a spurious error. VBA is notoriously
bad a pinning down reference problems, and it tends to flag a seemingly
random function from the first referenced type library in the
Tools/References list, no matter what the problem actually is.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Gary Bartlett" wrote in message
...
Hi Everyone,

I've put together an Excel workbook that accesses an Access database.

It works fine on Windows XP / Excel 2002/3, but objects to VB statements
like TRIM (Compile Error: Can't find project or library), crashes Excel
and
won't load any versions of the workbook it has saved on Windows 2000 /
Excel
2000.

I've discovered that the missing library is Shappmgrp 1.0 Library, but
can't
work out how to find the library or fix the problem.

I suspect that the library is either part of a Windows XP install or comes
with some other application development environments, because the workbook
also works fine under Windows XP 2002 / Excel 2000.

Anyone with any ideas? I'm desperate for a solution by my (New Zealand)
Monday morning - upgrading Windows or Excel is not an option for my
client..

Thanks very much.

Rgds

Gary

Gary Bartlett - Productivity Solutions



Phone 0800 776-276 (NZ) / +64 9 476-2530 (International)

Mobile +64 274 776-276

Fax +64 9 478-8747

http://prodsol.co.nz - dramatic improvement through pattern-level
intervention