Excel 97: Trim does not work in programming section

  • Thread starter Thread starter Jim Mooney
  • Start date Start date
J

Jim Mooney

I don't know why Trim(...) function does not work in the
Excel programming section of a worksheet for Excel 97. I
also have a copy of Office 2003 and it works fine with
this version.

How do I convert this statement in Office 2003:

Name = Trim(Name)

to work in Office97? The error keeps coming up:

Can't find project or library

Trim is highlighted.
 
Hi Jim,

It's not the Trim function that isn't working. You've referenced some
other object library in your project that doesn't exist on the Excel 97
machine. On the Excel 97 machine you'll need to go into the Visual Basic
Editor and choose Tools/References from the menu. One of the selected
References should be prefixed with MISSING. You'll either need to remove
this reference from your project or find a way to install the missing item
on the Excel 97 computer.

--
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 *
 
Back
Top