Find File

  • Thread starter Thread starter jln via OfficeKB.com
  • Start date Start date
J

jln via OfficeKB.com

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.
 
I removed som space around the *

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

filename = dir(MyPath)
 
Sorry Joel That doesnt seem to find the file.
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
Click to expand...
[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.
Click to expand...
Click to expand...
 
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
Sorry Joel That doesnt seem to find the file.
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
Click to expand...
[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.
Click to expand...
Click to expand...
Click to expand...
 
Joel

I see what your saying now when I add \ctj*.csv it stops working
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.
Click to expand...
[quoted text clipped - 10 lines]
Click to expand...
 
Back
Top