Open File Dialog using VBA

Here MS Excel related topics will be posted.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Open File Dialog using VBA

Post by admin »

Sub FileDialogOpen()

' Open File Dialog to only select multiple Excel files
' ERPstuff.com

With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = True
.Filters.Add "Excel Files", "*.xlsx; *.xlx", 1
.Show

For i = 1 To .SelectedItems.Count
MsgBox .SelectedItems(i)
Next i

End With

End Sub
file_dialog.png
file_dialog.png (41.46 KiB) Viewed 9230 times
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests