On the flip side of that, if the remote filename changes on a consistent basis (for example, the files are always named with the current date in yyyymmdd format), then you can prepopulate your get filename with the proper formatted date:
GetFileName = Format(Date,"yyyymmdd") & "Filename.txt" etc. Thank you, Mitch Lawrence Lead Applications Analyst Technical Support - NPR/Automation CHRISTUS Information Management *: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Send a "thank you <http://intranet.christushealth.org/spiritBuck/Default.asp> " to someone! ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bennett, Brian Sent: Thursday, March 13, 2008 1:18 PM To: '[email protected]' Subject: RE: [Talk] FTP Question Having not worked with BWS and FTP, I'm not sure if this is possible, but you might try reading the file name into a flag and then: If Trim$(Left$(F("FileName"), 8)) = Format(Date, "mm/dd/yy") then download the file End if. Brian Bennett Affinity Health Systems Systems Analyst PBS\Clinic Billing (920)628-9055 [EMAIL PROTECTED] ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gary Williams Sent: Thursday, March 13, 2008 12:59 PM To: [email protected] Subject: [Talk] FTP Question I have a script that needs to get 3 files from a vendors ftp site. The files names change daily as the first part of the name is the days date. I seem to be able to get it to work if the name is the same but I can figure out how to take the variable name into account. Thanks, Gary Williams
<<image001.png>>
