View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Doug[_11_] Doug[_11_] is offline
external usenet poster
 
Posts: 3
Default Trim Function - Error Library Not Found

It is Excel 97.

See previous thread.

"Cesar Zapata" wrote in message
...

is that computer a excel 97? or older version that the one where the
macro was created?

try this.

use strings.trim instead of just trim.


give it a shot.

Cesar



Doug wrote:
We have a excel spread sheet that has a bunch of VBA in it. It works on

99%
of the PC's. It fails on one PC. When the person opens it, it errors in

the
VBA, and highlights the Trim function. It says Libarary Not Found. I
verified that they has the same references as me.

I have the following references -
VBA332.dll
Excel8.olb
StdOle2.tlb
FM20.dll
MSO07.dll

Anyhelp would be great.