Copy text file from web server to local drive

[Cliff72]

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

[Tom van Stiphout]

On Thu, 11 Oct 2007 00:13:26 -0000, Cl*****@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.

>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

[Cliff72]

On Oct 10, 6:59 pm, Tom van Stiphout <[e-mail]:

On Thu, 11 Oct 2007 00:13:26 -0000, [e-mail] 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.

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- Hide quoted text -

- Show quoted text -

Thanks for your input.