I have a few scripts that do something similar to this..... I have
tackled it in a couple different ways.
1st.... I have an FTP vb module (free on the web) that I use, I
download a directory listing and find the most recent file and download
it (whatever the name... I use the date modified attribute).
2nd... If I know for sure what the filename should be I would do
something like this:
Dim tmpDate as string
Dim tmpFile as string
Dim tmpExt as string
Dim tmpFileName as string
tmpDate = Format(Now,"YYYYMMDD") ' Using the format function you can
arrange the date in any order you would like.
'You could also use the DateAdd function in here to get a past date:
tmpDate = Format(DateAdd("d",-1,Now),"YYYYMMDD")
YYYYMMDD is year, month, date.... You can also rearrange this in
whatever order you need.
tmpFile = "SomeFile"
tmpExt = ".txt"
tmpFileName = tmpfile & tmpDate & tmpExt
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Williams
Sent: Thursday, March 13, 2008 10:59 AM
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
CONFIDENTIALITY NOTICE: This message and any included attachments are from
Salinas Valley Memorial Healthcare System and are intended only for the
addressee. The information contained in this message is confidential and may
constitute inside or non-public information under international, federal, or
state securities laws. Unauthorized forwarding, printing, copying,
distribution, or use of such information is strictly prohibited and may be
unlawful. If you are not the addressee, please promptly delete this message
and notify the sender of the delivery error by e-mail or you may call Salinas
Valley Memorial Healthcare System's Privacy Officer in Salinas, California,
U.S.A. at (+1) (831) 755-0751.
