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

--
stevetan201
-----------------------------------------------------------------------
stevetan2010's Profile: http://www.excelforum.com/member.php...fo&userid=1624
View this thread: http://www.excelforum.com/showthread.php?threadid=27647

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

stevetan2010 wrote:

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

--
stevetan2010
------------------------------------------------------------------------
stevetan2010's Profile: http://www.excelforum.com/member.php...o&userid=16240
View this thread: http://www.excelforum.com/showthread...hreadid=276473

--

Dave Peterson