![]()
Sub InsertFromFolder() ' dialog Set objFSO = CreateObject("Scripting.FileSystemObject") InitialFoldr$ = "E:\Documents\Images\" '<<< Startup folder With Application.FileDialog(msoFileDialogFolderPicker) 'User input for folder to look at .InitialFileName = Application.DefaultFilePath & "\" .Title = "Please select a folder to list Files from" .InitialFileName = InitialFoldr$ .Show If .SelectedItems.Count = 0 Then Exit Sub mfolder = .SelectedItems(1) & "\" End With strExtension = Dir(mfolder & "*.jpg") ' change extension r = 1 Do While strExtension <> "" Rows(r).RowHeight = 55 ' to be changed Cells(r, 2).Select ActiveSheet.Pictures.Insert (mfolder & "\" & strExtension) ActiveCell.Offset(, -1).Value = strExtension r = r + 1 strExtension = Dir Loop End Sub
Bookmarks