View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Sorby Sorby is offline
external usenet poster
 
Posts: 3
Default 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