problem in excel 2002 and windows xp
 

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

problem in excel 2002 and windows xp
 

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

--
Regards,
Tom Ogilvy

"aries58" wrote in message
...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

problem in excel 2002 and windows xp
 

As always, post your code but NOT a workbook.

"aries58" wrote in message
...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

problem in excel 2002 and windows xp
 

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

problem in excel 2002 and windows xp
 

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.

--
regards,
Tom Ogilvy

"aries58" wrote in message
...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

problem in excel 2002 and windows xp
 

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

"aries58" wrote in message
...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

problem in excel 2002 and windows xp
 

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?


-----Original Message-----
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

.