By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,497 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Copy text file from web server to local drive

P: n/a
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

Oct 11 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Oct 11 '07 #2

P: n/a
On Oct 10, 6:59 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
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.
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.

Oct 11 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.