Need some help and explaination. Thks.

[stevetan2010]

Ok I have found the problem related to my second problem it seems tha
the .Filename is unable to accept filesearch wildcard. (*) Can anyon
tell me why

 

[Dave Peterson]

There was a thread a few months ago about this kind of thing.

IIRC, it was based on the version of windows--not excel (but it's been a long
time!).

How about checking your filenames before you do anything with them?

Dim MyName as string

'lots of code

If .Execute() > 0 Then
For iCtr = 1 To .FoundFiles.Count
myName = Mid(.FoundFiles(iCtr), _
InStrRev(.FoundFiles(iCtr), "\") + 1)
if lcase(myname) like "*idd_*.xls" then
'do something
else
'don't
end if
Next iCtr
End If