I recorded the following macro to "insert an image from file" the only problem is that it inserts the same image everytime. I would like it open the image from file dialog box and allow me select the image? Can someone tell me what I am doing wrong. I'm still quite new to macros but I'm trying. Thanks a lot!
Sub InsertImage()
'
' InsertImage Macro
' Macro recorded 12/19/2007 by LAMBERT
'
Selection.InlineShapes.AddPicture FileName:= _
"C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Blue hills.jpg" _
, LinkToFile:=False, SaveWithDocument:=True
End Sub
Sub InsertImage()
'
' InsertImage Macro
' Macro recorded 12/19/2007 by LAMBERT
'
Selection.InlineShapes.AddPicture FileName:= _
"C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Blue hills.jpg" _
, LinkToFile:=False, SaveWithDocument:=True
End Sub