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