I removed som space around the *

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

filename = dir(MyPath)


"jln via OfficeKB.com" wrote:

OK what im trying to do is this

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

Where the * is I need to find the file in this folder name is CTJ current
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