Joel

I see what your saying now when I add \ctj*.csv it stops working

Joel wrote:
I it finding any files or is it just returning an empty string? There may be
multiple files meeting the same criteria.

If it returning nothing then you need to debug the code yourself.
try this
MyPath = "Q:\FTP\as400\WinRAR\Production\Inv" & inv & "\*.csv"
filename = dir(MyPath)

See if this returns a file. if it does, then keep on adding your parameters
on the end of Mypath until it stops returning data. This should help you
isolate where the problem is located.

Sorry Joel That doesnt seem to find the file.

[quoted text clipped - 10 lines]
month INV number then _ and after the under score it could be any combo of
numbers. The file will always have CTJ at the start.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200712/1