Importing pictures to Excel

I have experience with VBA but no experience working with pictures. I have found 2 different Macros that will handle importing a picture. My question is can someone explain the difference between the two methods of locating the picture. see code below.

the first method only shows the file name, but it does handle the picture and place it where I want it

the second method shows thumbnails, but I'm having a hard time getting the picture where I want it, but I like being able to see what I'm getting.
I tried to just copy the line from second macro and replace the line in the first macro. that did not work. educate me please.


Sub InsertPicture()
Dim sPicture As String, pic As Picture


sPicture = Application.GetOpenFilename _
("Pictures (*.gif; *.jpg; *.bmp; *.tif), *.gif; *.jpg; *.bmp; *.tif", _
, "Select Picture to Import")



If sPicture = "False" Then Exit Sub
Range("a8").Select
Set pic = ActiveSheet.Pictures.Insert(sPicture)
With pic
.ShapeRange.LockAspectRatio = msoFalse
.Height = ActiveCell.Height
.Width = ActiveCell.Width
.Top = ActiveCell.Top
.Left = ActiveCell.Left
.Placement = xlMoveAndSize
End With

Set pic = Nothing
end sub

***********************
Sub option_2()

Dim MyWidth As Double
Dim MyHeight As Double
'----------------------------------------------------------
'- check for existing picture
If ActiveSheet.Pictures.Count > 0 Then
rsp = MsgBox("There is an existing picture. " & vbCr _
& "Do you wish to delete it ?", vbYesNoCancel)
If rsp = vbCancel Then Exit Sub
If rsp = vbYes Then
ActiveSheet.Pictures(1).Delete
End If
End If
'-----------------------------------------------------------


'- get new picture
Application.Dialogs(xlDialogInsertPicture).Show
'- may not have inserted a picture


If ActiveSheet.Pictures.Count > 0 Then
'- resize
MyWidth = ActiveSheet.Range("C11").Left
MyHeight = ActiveSheet.Range("C11").Top
Selection.Top = 1
Selection.Left = 1
Selection.Width = MyWidth
Selection.Height = MyHeight
Else
MsgBox ("No picture inserted.")
End If
End Sub

AlpaFrog i see your using 2003. I'm using 2007. I do not see the option you mentioned. Please allow for ignorance on my part. until 2 days ago I had no need or desire to work with pictures. What you refer to may be obvious to you, but I see nothing in the dialog box about views. using the second macro, thumbnail views are there. my assumption is that there is a difference in how the two methods work.

I do appreciate the help.

Alphafrog It does help when you know what you are looking for. I'm a minimalist when it comes to computers. If I'm not using it it don't need to be on. thanks for your help.

SHG this code is easier for me to read and it does what I was looking for. thanks

After seeing his last post I did find it. it was in a drop down menu that i had forgot about. I'm told getting old has some advantages. have yet to find any.