Saving GIF images from worksheet using VBA
Thanks for the prompt response Tom,
Sadly I don't have ftp access to the website in question.
Could I force the image to be opened in an IE window and instruct IE to save
the file (i.e. via 'Save picture as...") programatically?
Thanks again
--
Sorby
"Tom Ogilvy" wrote in message
...
Believe Export and possibly Strato's solution are for saving a picture
originally located in an excel spreadsheet (or a picture of a range or
something like that). If you have a url in your worksheet that refers to
a
gif file, then you probably want to use ftp to retrieve it and save it to
a
local directory rather than open it in excel. A lot would depend on
whether
you can access the file with ftp or not.
--
Regards,
Tom Ogilvy
"Sorby" wrote in message
...
Hi - can someone help me please?
For each row in my worksheet I need to be able to retrieve (from a URL)
a
GIF image and save it to a folder on my hard-drive.
The URL strings includes some data from the corresponding row.
Any ideas or pointers please?
Searching this ng I found references to using chart.export and even
Stratos's low-level binary solution (from machine memory rather than a
URL)
but are these really the best and only options?
Thanks
--
Sorby
|