string functions disappear after upgrade
 

Hi,

I have a relatively extensive VBA project, built in Excel 2003. Whe
users who have older versions of Excel (say 2000) upgrade to 2003 the
use my application, simple string functions like "Trim" and "Mid" n
longer work--VBA reports that the function/library was not found (the
don't even work when invoked in the immediate window). Most people
however, don't have this problem--it seems only to occur to those wh
recently upgraded. Does anyone know what might be going on?

i should also mention that if you open a new workbook, then th
functions _do_ work.

thanks

--
mmm999
-----------------------------------------------------------------------
mmm9999's Profile: http://www.excelforum.com/member.php...fo&userid=2646
View this thread: http://www.excelforum.com/showthread.php?threadid=39732

string functions disappear after upgrade
 

this is cause by a bad reference in the vbe for that workbook.

in the problematic workbooks/machines, after the error occurs, go into tools
references in the VBE (with this project selected in the project explorer in
the VBE) and you should see at least on Library marked as MISSING. You need
to unselect that library or find it using the browse button as appropriate.

--
Regards,
Tom Ogilvy

"mmm9999" wrote in
message ...

Hi,

I have a relatively extensive VBA project, built in Excel 2003. When
users who have older versions of Excel (say 2000) upgrade to 2003 then
use my application, simple string functions like "Trim" and "Mid" no
longer work--VBA reports that the function/library was not found (they
don't even work when invoked in the immediate window). Most people,
however, don't have this problem--it seems only to occur to those who
recently upgraded. Does anyone know what might be going on?

i should also mention that if you open a new workbook, then the
functions _do_ work.

thanks.


--
mmm9999
------------------------------------------------------------------------
mmm9999's Profile:
http://www.excelforum.com/member.php...o&userid=26464
View this thread: http://www.excelforum.com/showthread...hreadid=397326