Excel Macro to download most recent file from a URL.

[abhay_547]

Hi All,

I want to come up with a macro which will download the most recent file from a URL by checking it's modified date. For example I have the files reflecting on my URL in the below way.

File Name ---------- Modified Date
abc_2010-10-16 --------- 17-10-2010 6.30pm
abc_2010-10-13 ---------- 14-10-2010 7.15pm

The files are not uploaded on regular basis so I can't use the dates as parameters and download the most recent file. I want the macro to check the modified date of all the files which are available on the URL and then download the most recent file from the same consider the name of the same .i.e. it should search for a file the name of which file starts or contains with "abc" and then check it's modified date and download the most recent file from URL.

I have done some research on this and so far I have found some stuff on the below link.

http://forums.techguy.org/business-a...ated-file.html

As of now I have the below code to download the file from a URL.

Please Login or Register  to view this content.

Thanks a lot for your help in advance.