ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   FileSearch FileName using wildcard (?) (https://www.excelbanter.com/excel-programming/331946-filesearch-filename-using-wildcard.html)

Werner Rohrmoser

FileSearch FileName using wildcard (?)
 
Hello,

Application: Excel XP SP2
Environment: Windows XP SP1

Problem:
I use "???5??.xls" as the argument for the FileName property of
the FileSearch object.
After my procedure has done I do not get only files named
"???5??.xls", but also files, which are named "????????5??.xls".
Their name length is more than 10 characters, I thought my filter
limits the files found to files with a name length of 10 characters.

Does anyone know what I'm doing wrong?

Regards
Werner


keepITcool

FileSearch FileName using wildcard (?)
 

many people have complaints about office' filesearch.
use scripting filesystemobject
google for examples


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Werner Rohrmoser wrote :

Hello,

Application: Excel XP SP2
Environment: Windows XP SP1

Problem:
I use "???5??.xls" as the argument for the FileName property of
the FileSearch object.
After my procedure has done I do not get only files named
"???5??.xls", but also files, which are named "????????5??.xls".
Their name length is more than 10 characters, I thought my filter
limits the files found to files with a name length of 10 characters.

Does anyone know what I'm doing wrong?

Regards
Werner



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

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