Insert image, get name of image
The recorder will get picture if you use INSERT - Picture. The code below
lets you get a filename and then paste the picture.
filetoopen = Application _
.GetOpenFilename("Picture Files (*.jpg), *.jpg")
If filetoopen < False Then
MsgBox "Open " & filetoopen
End If
ActiveSheet.Pictures.Insert(filetoopen).Select
"Rick S." wrote:
Can I insert an image and pass the file name of the image to a varaible?
Using macro recorder doesn't show anything involved with inserting an image.
--
Regards
XP Pro
Office 2007
|