This is perfect! Thank you so much!!!!!!!!
Gary
----- Original Message -----
From: TIMOTHY B. FRANCE
To: [email protected]
Sent: Friday, March 14, 2008 11:41 AM
Subject: RE: [Talk] FTP Question
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.
