problem in excel 2002 and windows xp

[aries58]

I have installed in a computer running windows xp pro, office xp,
but excel does not recognize a lot of native function of VBA,
like MID(x,y,z), RIGHT(n,s) etc ....When I run a macro, it appears the
debugger window telling me that the above mentioned function are not
recognized !!!!!!!!!!

Tried several solution ( reinstallations ..and so on) ..it is a
riddle!!
I really can't figure out what can it be...

In my computer I have made "exactly" the same procedure and everything
works well....can any beautiful soul help me????

TIA

Aries58

 

[Tom Ogilvy]

Sound like you have a bad reference in Tools=>References. See if you have a
reference shown as MISSING.

 

[Don Guillett]

As always, post your code but NOT a workbook.

 

[aries58]

Here a symple code sample which does not work!!

k = "SSSSSSSSSSS"

s = MID(k , 3 , 3)

msgbox s

I should get a message containing "sss"
I have a message from the dedugger which does not recognize the MID
function!! Anyway I cut and past a lot of part of code wich works in
my computer , i.e. is not any mismatching problem.

TIA

Aries58

 

[Tom Ogilvy]

You already received the answer to look in tools => references. This is the
source of your problem more than likely. It has nothing to do with your
code.

 

[Don Guillett]

Leave Excel and come back or try a re-boot. Sometimes, it works wonders.

 

[Guest]

I have the same problem - seems to be the reference
library section... I have reinstalled office and upgraded
to office xp sp2. is there an answer out there?