Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 88
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
set filename to <filename-date on open bob engler Excel Worksheet Functions 2 July 13th 06 05:11 AM
Wildcard for numeric characters in filename? Jeff[_41_] Excel Programming 4 December 6th 04 10:32 PM
FileSearch Stephen[_6_] Excel Programming 8 June 12th 04 11:14 PM
Saving filename same as import filename Matt Excel Programming 4 February 24th 04 03:01 PM
FileSearch for a TextorProperty with a wildcard myensr Excel Programming 1 December 10th 03 09:49 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"