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 |
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 |
All times are GMT +1. The time now is 12:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com