ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   2003--2007 Mid function (https://www.excelbanter.com/excel-programming/394958-2003-2007-mid-function.html)

Miri

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.

RB Smissaert

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.



Bob Phillips

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.





All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com