Dim fl, i As Integer, fildialog As Variant
Sub LoadImageFile()
Set fildialog = Application.FileDialog(msoFileDialogFilePicker)
With fildialog
.AllowMultiSelect = True
.Title = "Select Image"
.Filters.Clear
.Filters.Add "Image Files", "*.jpg,*.bmp,*.png,*.gif"
i = 1
If .Show = True Then
For Each fl In .SelectedItems
ThisWorkbook.Sheets(1).Range("A" & i) = fl
i = i + 1
Next
Else
MsgBox "Precess cancelled"
End If
End With
End Sub
Sub LoadImageFile()
Set fildialog = Application.FileDialog(msoFileDialogFilePicker)
With fildialog
.AllowMultiSelect = True
.Title = "Select Image"
.Filters.Clear
.Filters.Add "Image Files", "*.jpg,*.bmp,*.png,*.gif"
i = 1
If .Show = True Then
For Each fl In .SelectedItems
ThisWorkbook.Sheets(1).Range("A" & i) = fl
i = i + 1
Next
Else
MsgBox "Precess cancelled"
End If
End With
End Sub
No comments:
Post a Comment