Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi,
i'm running macro that was run properly in 2003. now in 2007 it does not recognize the Mid() function of String. what can it be? and how can i fix it? it also happened with Date of Datetime. probably mising library.. how to fix it? thanks, -- Miri Tz. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This sounds like a missing reference in the project and it most likely has
nil to do with the Mid function. In the VBE do Tools, References and see which one is missing and take it from there. RBS "Miri" wrote in message ... hi, i'm running macro that was run properly in 2003. now in 2007 it does not recognize the Mid() function of String. what can it be? and how can i fix it? it also happened with Date of Datetime. probably mising library.. how to fix it? thanks, -- Miri Tz. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In the VBIDE (Alt-F11), go to ToolsReferences, and uncheck any items that
have MISSING alongside. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Miri" wrote in message ... hi, i'm running macro that was run properly in 2003. now in 2007 it does not recognize the Mid() function of String. what can it be? and how can i fix it? it also happened with Date of Datetime. probably mising library.. how to fix it? thanks, -- Miri Tz. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2003 function moved to 2007 unable to change absolute references | Excel Worksheet Functions | |||
MATCH function (2003 - 2007) | Excel Discussion (Misc queries) | |||
Function dosn't work in Excel 2007 but did in 2003 | Excel Worksheet Functions | |||
Sorting function in Excel 2003 lost in the 2007 version | Excel Worksheet Functions | |||
Snapshot function, 2003 to 2007 | Excel Worksheet Functions |