View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default 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