Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFilePicker)
Dim vrtSelectedItem As Variant
With fd
.Title = "サンプルダイアログ(ファイル参照)"
.Filters.Clear
.Filters.Add "テキスト", "*.txt; *.csv"
.Filters.Add "エクセル", "*.xls"
.Filters.Add "Access", "*.mdb"
.Filters.Add "イメージ", "*.gif; *.jpg; *.jpeg"
.Filters.Add "すべてのファイル", "*.*"
.FilterIndex = 5
.InitialView = msoFileDialogViewDetails
.InitialFileName = CurrentProject.Path
.AllowMultiSelect = True
If .Show = -1 Then
For Each vrtSelectedItem In .SelectedItems
Debug.Print "選択したアイテムのパス : " & vrtSelectedItem
Next vrtSelectedItem
Else
End If
End With
Set fd = Nothing
Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFolderPicker)
Dim vrtSelectedItem As Variant
With fd
.Title = "サンプルダイアログ(フォルダ参照)"
.InitialView = msoFileDialogViewDetails
.InitialFileName = "D:\"
If .Show = -1 Then
For Each vrtSelectedItem In .SelectedItems
FDFolderPicker = vrtSelectedItem
Next vrtSelectedItem
Else
End If
End With
Set fd = Nothing
Access_Tips_Dialog ボックスを表示する方法 - Access_VBA講座