Copy text file from web server to local drive

>Is there a way in VBA to copy a file from a web server to a local
>drive? Example:
>Every morning at 3AM a huge mainframe report is run and a copy of
>this report is saved as a text file on a web server:
>http://GLJobs.CliffKing.com/Reports_...port101007.txt
>The name of my report is:
>MyReport101007.txt
>
>I manually download this report to the C:\ drive and then manually
>import it into access.
>Is there a way i can programmatically do this?
>
>Thanks
>
>Cliff

On Thu, 11 Oct 2007 00:13:26 -0000, Clif...@gmail.com wrote:
>
Yes. Look into the XMLHTTP object, which has methods to get the
content of a web page. I've never used it to download a file, but
would not be surprised if that worked.
FTP is another way, assuming you have FTP access to the site.
>
-Tom.
>
>
>>>>>
- Show quoted text -