URLDownloadToFile API

Hi Folks,
I've been using this to update files with some success but.....I wish to
modify my code. At the moment it takes the file from the server and
updates the copies regardless of version. This is fine (or has bene up
to now at least) as I always make sure the files on the server are the
latest versions.

I'd like to check if the file is of a certain date before downloading it
is this possible?

Cheers

J

Jay
Wed Dec 08 09:24:00 CST 2004

JB wrote:
> Hi Folks,
> I've been using this to update files with some success but.....I wish
> to modify my code. At the moment it takes the file from the server
> and updates the copies regardless of version. This is fine (or has
> bene up to now at least) as I always make sure the files on the
> server are the latest versions.
>
> I'd like to check if the file is of a certain date before downloading
> it is this possible?
>
> Cheers
>
> J

Check out the FileDateTime function, standard in VBA.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org

JB
Mon Dec 13 06:51:40 CST 2004

Jay Freedman wrote:
> JB wrote:
>
>>Hi Folks,
>>I've been using this to update files with some success but.....I wish
>>to modify my code. At the moment it takes the file from the server
>>and updates the copies regardless of version. This is fine (or has
>>bene up to now at least) as I always make sure the files on the
>>server are the latest versions.
>>
>>I'd like to check if the file is of a certain date before downloading
>>it is this possible?
>>
>>Cheers
>>
>>J
>
>
> Check out the FileDateTime function, standard in VBA.
>
Hi Jay,
Could I use this to check the stamp Before download?

J

Jay
Mon Dec 13 10:31:23 CST 2004

JB wrote:
> Jay Freedman wrote:
>> JB wrote:
>>
>>> Hi Folks,
>>> I've been using this to update files with some success but.....I
>>> wish to modify my code. At the moment it takes the file from the
>>> server and updates the copies regardless of version. This is fine
>>> (or has bene up to now at least) as I always make sure the files on
>>> the server are the latest versions.
>>>
>>> I'd like to check if the file is of a certain date before
>>> downloading it is this possible?
>>>
>>> Cheers
>>>
>>> J
>>
>>
>> Check out the FileDateTime function, standard in VBA.
>>
> Hi Jay,
> Could I use this to check the stamp Before download?
>
> J

Yes, the function takes one parameter -- the path/filename of the file --
and returns the file's date/time stamp. The file does not have to be opened
in Word or copied to a local drive.

The path can be either a mapped drive like "Z:\myfolder\myfile.doc" or a UNC
path like \\myserver\myshare\myfolder\myfile.doc. The result comes back as a
Variant in the format 3/29/1999 12:28:08 PM but you can treat it as a
String.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org

JB
Tue Dec 14 04:44:42 CST 2004

Jay Freedman wrote:
> JB wrote:
>
>>Jay Freedman wrote:
>>
>>>JB wrote:
>>>
>>>
>>>>Hi Folks,
>>>>I've been using this to update files with some success but.....I
>>>>wish to modify my code. At the moment it takes the file from the
>>>>server and updates the copies regardless of version. This is fine
>>>>(or has bene up to now at least) as I always make sure the files on
>>>>the server are the latest versions.
>>>>
>>>>I'd like to check if the file is of a certain date before
>>>>downloading it is this possible?
>>>>
>>>>Cheers
>>>>
>>>>J
>>>
>>>
>>>Check out the FileDateTime function, standard in VBA.
>>>
>>
>>Hi Jay,
>>Could I use this to check the stamp Before download?
>>
>>J
>
>
> Yes, the function takes one parameter -- the path/filename of the file --
> and returns the file's date/time stamp. The file does not have to be opened
> in Word or copied to a local drive.
>
> The path can be either a mapped drive like "Z:\myfolder\myfile.doc" or a UNC
> path like \\myserver\myshare\myfolder\myfile.doc. The result comes back as a
> Variant in the format 3/29/1999 12:28:08 PM but you can treat it as a
> String.
>
Thanks Jay.