View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
kvenku[_5_] kvenku[_5_] is offline
external usenet poster
 
Posts: 1
Default Left and Right function is not working

Hi,
Thanks for the information.
But MS Excel Object library is checked.even thou i am getting error.
I have to use iVersion=cint(left(cstr(application.version),2)) becaus
in
version 97
application.version is 8.0a
cint(left(cstr(application.version),2)) is 8

version 2000
application.version is 9.0
cint(left(cstr(application.version),2)) is 9

That's why i need left function. where the MS-office version 97 alon
is giving this error as 'Cannot foung project or library'.

Its very urgent..is there any other solution to do that
I am eagerly waiting for you.

Thanks

Venkates

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