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.