| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
distinguishing filenames
in Excel 2003
I'm using ... MyPath = ThisWorkbook.Path & "\" FilesInPath = Dir(MyPath & "*.ORG.2008BP.xls") to select files for processing how would I distinguish between files that are named #= single numeric character ##.####.ORG.2008BP.xls and ##.ORG.2008BP.xls "##.####.ORG.2008BP.xls" didn't work -- Jim |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
distinguishing filenames
The simpliest way is to check the legth of the filename
MyPath = ThisWorkbook.Path & "\" FilesInPath = Dir(MyPath & "*.ORG.2008BP.xls") if len(FileInPath) = 22 then else end if "JASelep" wrote: in Excel 2003 I'm using ... MyPath = ThisWorkbook.Path & "\" FilesInPath = Dir(MyPath & "*.ORG.2008BP.xls") to select files for processing how would I distinguish between files that are named #= single numeric character ##.####.ORG.2008BP.xls and ##.ORG.2008BP.xls "##.####.ORG.2008BP.xls" didn't work -- Jim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In 2007 I am having difficulty distinguishing highlighted areas | Excel Discussion (Misc queries) | |||
| distinguishing between cell formula, and the resulting text in cell | Excel Programming | |||
| ~~~ Distinguishing Normal; X1.5 and X2 Hours throughout the week by what day and time they are worked ~~~ | Excel Programming | |||
| distinguishing formula cells | Excel Discussion (Misc queries) | |||
| Distinguishing cell formula from value. | Excel Programming | |||
Linear Mode
