Option Explicit
Sub InsertPicture()
Dim HINAGATA_BOOK As Workbook
Dim myBOOK_FILE_NAME As String
Dim myCELL As Range
Dim myPICTURE_PATH_FILE_NAME As String
Dim myPICTURE_FILE_NAME As String
Dim mySTART_POSITION As Integer
Dim myPOSITON As Integer
myBOOK_FILE_NAME = _
Application.GetOpenFilename("Excel ファイル (*.xls), *.xls", _
Title:="写真を貼り付けるファイルを選んでください") '<---(1)
If myBOOK_FILE_NAME = "False" Then
Exit Sub '<---(2)
End If
Set HINAGATA_BOOK = Workbooks.Open(myBOOK_FILE_NAME) '<---(3)
Do '<---(4)
On Error GoTo ERRHANDLER1 '<---(5)
Set myCELL = _
Application.InputBox("写真を挿入する左上のセルを選択してください", Type:=8) '<---(6)
On Error GoTo 0 '<---(7)
myCELL.Select '<---(8)
myPICTURE_PATH_FILE_NAME = _
Application.GetOpenFilename("画像 ファイル (*.jpg), *.jpg,全ての ファイル (*.*), *.*", _
Title:="挿入する写真を選んでください") '<---(9)
If myPICTURE_PATH_FILE_NAME = "False" Then
Exit Sub '<---(10)
End If
myPOSITON = 0 '<---(11)
Do '<---(12)
myPOSITON = InStr(myPOSITON + 1, myPICTURE_PATH_FILE_NAME, "\") '<---(13)
If myPOSITON = 0 Then '<---(14)
Exit Do
End If
mySTART_POSITION = myPOSITON + 1 '<---(15)
Loop
myPICTURE_FILE_NAME = _
Mid(myPICTURE_PATH_FILE_NAME, mySTART_POSITION) '<---(16)
myCELL.Offset(-1, 0).Value = myPICTURE_FILE_NAME '<---(17)
ActiveSheet.Pictures.Insert(myPICTURE_PATH_FILE_NAME).Select '<---(18)
Selection.ShapeRange.Line.Weight = 1.5 '<---(19)
Selection.ShapeRange.Line.DashStyle = msoLineSolid '<---(20)
Selection.ShapeRange.Line.Style = msoLineSingle '<---(21)
Selection.ShapeRange.Line.Transparency = 0# '<---(22)
Selection.ShapeRange.Line.Visible = msoTrue '<---(23)
Selection.ShapeRange.Line.ForeColor.SchemeColor = 3 '<---(24)
Selection.ShapeRange.Line.BackColor.RGB = RGB(255, 255, 255) '<---(25)
Loop
ERRHANDLER1: '<---(26)
Set HINAGATA_BOOK = Nothing '<---(27)
Set myCELL = Nothing
End Sub