FileSearch FileName using wildcard (?)

W

Werner Rohrmoser

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
 
K

keepITcool

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


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


Werner Rohrmoser wrote :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wildcard for numeric characters in filename? 4
.FileSearch 4
problems using Filesearch object when files have a password 2
Strange problem with filesearch...help 4
FileSearch Problem 3
Problem with File.Search 11
Excel VBA SQL Query Filename 3
Automation Error: Object Disconnected From Clients 1

Top