Picture control

[EDUCATED MONKEY]

Hello I trying to put together some code that will copy and save a picture from the internet have copied it, then it needs to be renamed using the contents of a cell. and save to a folder on the C drive
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
More about the pictures these are freely available and not copy righted, I can copy rename and save them manually, as this take time to copy then type a new name for the selected picture then open folder and save it to that folder, I was hoping some as got some vba that will accomplish this, i have means of saving selected text which is

Worksheets("REMOVE UNWANTED ITEMS").Activate
Worksheets("REMOVE UNWANTED ITEMS").Range("A2").Select

ActiveSheet.PasteSpecial Format:="Text", LINK:=False, DisplayAsIcon:= _
False

but this does not give save picture option

 

[bensonsearch]

Hello I trying to put together some code that will copy and save a picture from the internet have copied it, then it needs to be renamed using the contents of a cell. and save to a folder on the C drive
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
More about the pictures these are freely available and not copy righted, I can copy rename and save them manually, as this take time to copy then type a new name for the selected picture then open folder and save it to that folder, I was hoping some as got some vba that will accomplish this, i have means of saving selected text which is

Worksheets("REMOVE UNWANTED ITEMS").Activate
Worksheets("REMOVE UNWANTED ITEMS").Range("A2").Select

ActiveSheet.PasteSpecial Format:="Text", LINK:=False, DisplayAsIcon:= _
False

but this does not give save picture option

are these pictures in a browser or the workbook?

if in workbook sure, if in browser i would add the browser object and work from it (using web browser object)

please advise

 

[EDUCATED MONKEY]

The pictures are in a browser ie or google chrome which ever would be the easest also once the picture has been saved need to close the connection other wise i end up with loads open, the pictures are of book authors all the stuff i have been putting to gether are for the same project

 

[bensonsearch]

The pictures are in a browser ie or google chrome which ever would be the easest also once the picture has been saved need to close the connection other wise i end up with loads open, the pictures are of book authors all the stuff i have been putting to gether are for the same project

thats a bit beyond my knowlegde. i know you can insert your own browser control and work from that but I dont know how to interface with external browsers. I would have thought vb.net would do that easier.

hope you find your answer

 

[RSXchin]

can you give us the Url? and will the Url change? and how? are the pictures always in the same location?

 

[Kenneth Hobson]

You should be able to adapt:

http://www.vbaexpress.com/forum/showthread.php?t=34206

which is based in part from:

http://vbnet.mvps.org/index.html?code/internet/urldownloadtofilenocache.htm
http://www.mrexcel.com/forum/showthread.php?t=116387