File Dialog in Xl 2004 on Mac?
On a windows machine I can use the following code to pop a file explorer dialog to select a folder.
[VBA] If IsWindowsOS Then
With Application.FileDialog(msoFileDialogFolderPicker)
.AllowMultiSelect = False
If .Show = -1 Then
FilePath = .SelectedItems(1)
' MsgBox .SelectedItems(1)
End If
End With
End If[/VBA]
Can XL on Mac (2004) do something like this to open the file dialog to select a folder or a file? Since the commands File > Open pops such a dialog, is it too much to hope that there is a simple, efficient way to search for folders and/or files?
Thanks!