Hi,
I have this little script to open a .csv file.
However, i would like to 'lock' the folder path without the filename too, so that i can call it again in later steps of the macro, to save the files in the same dir.
fStr is set as the selected file.![]()
Dim fStr As String With Application.FileDialog(msoFileDialogFilePicker) .Show If .SelectedItems.Count = 0 Then MsgBox "Cancel Selected" Sheets("Dashboard").Select Exit Sub End If 'fStr is the file path and name of the file you selected. fStr = .SelectedItems(1) End With
What should i insert to save the folder path?
Thanks for all the help
Bookmarks