Compile error
 

i get an compile error when i use the functions UCase, Right, Left, and date

the error says

Compile Error
Cant find project or library

this is a new computer and i have all the refrence librarys selected on this
computer that i had on my last computer. any ideas?

Compile error
 

have you checked all your references in VBA? as some do get upgraded if
you move from one office version to another.

does it relate to another project? do you have the line which it stop
at?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=553248

Compile error
 

I did upgrade from office 97 to 2003

i have checked my references and all of them that i previously had checked
are currently checked.

the line is a simple statement such as

right("xxxxx",2)
or
ucase("xxxx")


"funkymonkUK" wrote:


have you checked all your references in VBA? as some do get upgraded if
you move from one office version to another.

does it relate to another project? do you have the line which it stop
at?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=553248

Compile error
 

if you want you can PM me your code across and I could look at it for
you.

it might be the why in which it is used that is conficting. i think its
a compatiblitie issue which could be sorted out with a lil bit of
knowledge


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=553248