hi
i have a function to open file dialog, how can i pre set the folder location
heres my code
i have a function to open file dialog, how can i pre set the folder location
heres my code
Code:
Function selectFile()
Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFilePicker)
fd.AllowMultiSelect = False
fd.Title = "Plase Select The Latest Run in."
fd.Filters.Clear
fd.Filters.Add "Excel Spreadsheet", "*.xls, *.xlxs"
With fd
If .Show Then
selectFile = .SelectedItems(1)
Else
'stop execution if nothing selected
End
End If
End With
Set fd = Nothing