| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Equivalent for Excel Function
I am looking for the VBA equivalent for the following function:
=isnumber(value(mid("Export20090224.xls",7,8))) What I am trying to do is make sure that when the user saved the filename that they entered the date properly as in 20090224 rather than 2009224. Maybe this is a weak approach as I am just testing for the length more than enything else. Can I get the date from the 'saved date' stamp pehaps? If there is an even better way of doing this, then that would be great. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NZ function equivalent in Excel | Excel Worksheet Functions | |||
| Countifs function equivalent for Excel 2002 (XP) | Excel Worksheet Functions | |||
| Lotus 123 @nsum function equivalent in excel(?) | Excel Worksheet Functions | |||
| Excel equivalent to Eval function | Excel Programming | |||
| What is the Excel equivalent of the CELL function? | Excel Worksheet Functions | |||
Threaded Mode
