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

VBA code to save file from http to hard drive?

P: n/a
Hi all,

I'm sure this is simple, I'm just not up on anything like VBA syntax &
functions.

I need an Access 2002/VBA code that gets an XL file from
http://www.somewhere.com/name.xls and saves it to the hard drive under
somename.xls

Can anyone show me how to do this?

tia,

cdj

Aug 16 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi Tia,

You can use ftp.exe which is a command line utility program that comes
with Microsoft windows. Here is a link that explains the usage from
Access in a little more detail

http://www.mvps.org/access/modules/mdl0015.htm

You can also use wininet.dll. You can find a sample application on the
msdn knowledge base.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Aug 16 '06 #2

P: n/a

Rich P wrote:
Hi Tia,
lol! "tia" means "thanks in advance" in internet-ese - sorry for the
confusion. ("lol" means "laughing out loud")
You can use ftp.exe which is a command line utility program that comes
with Microsoft windows. Here is a link that explains the usage from
Access in a little more detail
Drat - I was hoping it would be as simple as using the
filesystemobject's copyfile method. (In particular, I was about to look
into putting a url into the Source argument slot.)
http://www.mvps.org/access/modules/mdl0015.htm
Thanks - will follow-up on these hints.

Aug 16 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.