Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find File
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find File
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find File
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find File
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. "jln via OfficeKB.com" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find File
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find a deleted excel file? Or an autosave file? | Excel Discussion (Misc queries) | |||
how to find find last file name and increment - XL2000 | Excel Programming | |||
clicking .XLS file opens Excel 2003 but doesn't find the file | Excel Discussion (Misc queries) | |||
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
Want file title listing as in Excel 5.0 File>Find | Excel Discussion (Misc queries) |