Venkatesh,

Another reason could be that there are items in ToolsReferences that are
showing up as missing, other than Office. Check if there are any others, and
remove them if so.

By the way, even if that is so, you do not need then CStr as Version is a
string.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"kvenku " wrote in message
...
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)) because
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 alone
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

Venkatesh


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