Re: Left and Right function is not working

From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 04/28/04 

Date: Wed, 28 Apr 2004 13:30:54 +0100

Venkatesh,

Another reason could be that there are items in Tools>References 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 >" <<kvenku.15f9hq@excelforum-nospam.com> wrote in message
news:kvenku.15f9hq@excelforum-nospam.com...
> 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/
>

Relevant Pages

  • Global distribution List Not Appearing in Outlook Global Selections list
    ... For some reason the list is not showing in the Outlook ... What am I missing? ...
    (microsoft.public.exchange.admin)
  • Re: A few minor bugs
    ... Applying a polearm and missing a friendly or tame creature does not ... Wiping, on the other hand, is a very specialized command that only applies to a single specific situation. ... I see no reason to punish the user for either of these situations. ...
    (rec.games.roguelike.nethack)
  • Re: NULLs: theoretical problems?
    ... be missing. ... The specific reason might or might not be of interest to the ... the reason why the contract was terminated - I'm pretty sure that you'd ... termination date and the reason why the contract is NOT terminated in a ...
    (comp.databases.theory)
  • Re: [opensuse] Am I the only one?
    ... laudable goals, but until I see a compelling reason to use it, I ... KDE4 and then create a site that we can vote on the features that are ... missing, I will be sure to add my input. ... RAM while I have 4 ssh sessions into my server running 2 movie ...
    (SuSE)
  • Re: Earth resistance
    ... showing very low resistance (negative for some reason on my cheapy ... and the other is showing around 50 ohms. ... 50 ohms is far too high - I doubt it ever was a true earth connection. ...
    (uk.rec.cars.maintenance)