Excel 97: Trim does not work in programming section

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.
 
R

Rob Bovey

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 *
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trim: Excel 97 gives error "Can't find project or library" 10
Reference for Trim$ ??? 8
Trim Function... does not work? 7
Excel 97 Left(..... 3
Trim in Query Error 1
user define not defined 1
TRIM Function gives Compiler Error!!!! 6
why does tha format$ and trim function no longer work in access 4

Top