problem in excel 2002 and windows xp

  • Thread starter Thread starter aries58
  • Start date Start date
A

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
 
Sound like you have a bad reference in Tools=>References. See if you have a
reference shown as MISSING.
 
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
 
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.
 
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?
 
Back
Top