VBA TIPS
Placing a picture into the Worksheet from web

It is very simple. Insert Method works as it is.

The following code will insert a picture to the worksheet from my junk room site. The picture will be place on the ActiveCell.



To get the url of the picture on the Internet Explore, right crick on the picture and see the property. The url will be shown as follows. (sorry it's a screen shot from the Japanese version IE)



Option Explicit

Sub InsertPicture()
    ActiveSheet.Pictures.Insert "http://www.puremis.net/excel/data/cube.gif"
End Sub




| HOME |
Copyright © cellmasters.net - colo's junk room All Right Reserved
ABOUT
WORKS
THE CELL MASTERS
CONTACT
LINKS
Tips and Information about Microsoft Excel|Masaru Kaji aka Colo