I'm trying to select an Excel file from SharePoint using VBA. Because the file I'm looking for might be different each time I run the macro, I want to be able to view the SharePoint folder and select the file I need.
The code below works fine when I want to look for a file on a network drive, but it does not select the file with the button "OK". It just fills the dataname space with the selected file name and does not take / saves it.
By the way, opening works fine. Opening and extracting the name works but directly picking the file does not work.
Here is the code:
The code below works fine when I want to look for a file on a network drive, but it does not select the file with the button "OK". It just fills the dataname space with the selected file name and does not take / saves it.
By the way, opening works fine. Opening and extracting the name works but directly picking the file does not work.
Here is the code:
Code:
Set foDialog = Application.FileDialog(msoFileDialogFilePicker)
With foDialog
.Title = "Select " + fsFilePathArt + "-File "
.AllowMultiSelect = False
.InitialFileName = "Z:\Input_Data" +"\"
.InitialView = msoFileDialogViewDetails
If .Show = -1 Then
fsFullFileName = .SelectedItems(1)
Else
fsFullFileName = ""
End IfEnd With
Last edited: