Sorry Joel That doesnt seem to find the file.

Joel wrote:
I removed som space around the *

MyPath = "Q:\FTP\as400\WinRAR\Production\Inv" & inv & "\CTJ" & CurrentMonth
& inv & "_*.csv"

filename = dir(MyPath)

OK what im trying to do is this

[quoted text clipped - 4 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