Search results for query: *

I replaced the previous Shell command with the one from PH above. The FTP1 file shows: Open ftp://ftpus*...com/" User UserName Password bye The gen_CSVFilelist.dat shows: ftp> Unknown host ftp://ftpus2etc.com/ ftp> Open ftp://ftpus2etc.com/ Not connected. ftp> User...

Obviously my last msg should have read "since I DON'T follow/understand all your code..." !! OK, I did a search for that file, which was not found anywhere on C:\ but entered the path anyway. This is what I have at this point: Function GetFileList() Dim strFile, ln, l1, d1 Dim rs As...

Remou, When I run the code I get an error "File not Found" on "gen_CSVFileList.dat" in the line : Open "gen_CSVFileList.dat" For Input As #1 Since I follow all your code, I'm a bit lost. Thx.

Thanks Remou and Alex, I'll work on your suggestions and do more research on ftp downloading! Some of this is above my head but it's a good learning experience, right? Thanks so much!

If I have to go look for the date I may as well just drag it over. My plan is to not open up the ftp folder thus saving time.

Thanks much for your help. But even with the last advice to use double quotes, it doesn't bring in the file. Is each line of the Print... supposed to show inn the black wiindow? They don't at this point. Maybe I will have to type in the full name of the file since the file I need is not...

OK, I understand that, but after modifying the code below it does not bring in the indicated file. Where have I gone wrong? It opens a window, shows the Open ftp command, waits 12 seconds, then closes. strfile = "C:\_Projects\FTP1.txt" Open strfile For Output As #1 Print #1, "Open...

I have not used Print and Output in VBA before... "Print" shows in a window what's going on? Is the shell line what brings it over to C? Can I run it as modified below, per name of file (below) I want to get? "strfile" is where I want to save the file and the name of the file? Sub...

I need to have Access 2K select several files with Filename* based on the latest date from an ftp site. [ftp: Folder/Filename example: "Incoming\ABCD 20070223.csv"] and then download them to a Windows folder: C:\Projects\DataFiles\Filename*.* Can VBA or SQL do this? If so, could someone help...