View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Left and Right function is not working

Hi
in the VBA editor goto 'Tools - References' and check if
the MS Excel Object library is checked
-----Original Message-----
Hi,
I am using MS-office 97. In my application when i use

either
left,right,space,ltrim,rtrim or trim function a

message 'Cannot find
project or library' pops up.


I need to restrict the excel version below 2000.
I am using
iVersion=cint(left(cstr(application.version),2) )
to find the version. But getting 'cannot find the project

or library'
message.

How to proceed further..can you help me out

Thanks
Venkatesh.


---
Message posted from http://www.ExcelForum.com/

.