View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Auric__ Auric__ is offline
external usenet poster
 
Posts: 538
Default Copy files from website?

Robert Crandal wrote:

I use Excel 2007 with VBA at work. We also have a company
website that, I believe, is an Intranet only website.

Is it possible to use VBA to extract images from our company
website and copy them to a local folder?

For example, if I type "http://blue/our_site/img/444.001.jpg" in my
Internet Explorer browser at work, an image will load on my
browser. Are there VBA functions that take a URL as above
and copy the file to a target location??


Does it *need* to be VBA? While VBA certainly can do it, it's much simpler to
use a download manager like wget or curl from the command line:
cd "local folder"
wget http://blue/our_site/img/444.001.jpg

--
You seldom learn the names of the truly wealthy and powerful.
You see only their spokesmen. The political arena makes a few
exceptions to this but does not reveal the full power structure.