Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 62
Default 2003--2007 Mid function

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default 2003--2007 Mid function

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default 2003--2007 Mid function

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2003 function moved to 2007 unable to change absolute references Sivart Excel Worksheet Functions 1 April 9th 09 08:15 PM
MATCH function (2003 - 2007) RL Excel Discussion (Misc queries) 2 April 6th 09 09:44 PM
Function dosn't work in Excel 2007 but did in 2003 Harding Excel Worksheet Functions 1 February 12th 08 04:05 PM
Sorting function in Excel 2003 lost in the 2007 version Kevin K[_2_] Excel Worksheet Functions 0 August 15th 07 02:32 PM
Snapshot function, 2003 to 2007 Brian T. Excel Worksheet Functions 2 August 10th 07 10:16 PM


All times are GMT +1. The time now is 09:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"