| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2002 problems in windows 7? | Excel Discussion (Misc queries) | |||
| need to convert excel 97 doc to windows xp 2002 home edition | Excel Discussion (Misc queries) | |||
| I could not opened Excel 2002 files from Windows Explorer | Excel Discussion (Misc queries) | |||
| Excel 2002 - Internet Explorer Windows opening up uncontrollably | Excel Worksheet Functions | |||
| Arrow keys in Excel 2002/running Windows XP | Setting up and Configuration of Excel | |||
Linear Mode
