I am using the following code to import XML files into an Access table:
Set fd = Application.FileDialog(msoFileDialogFilePicker)
.InitialFileName = "c:\sample\*.xml"
If .Show = -1 Then
For Each vrtSelectedItem In .SelectedItems
Set fd = Nothing
This has been working perfectly. But now instead of having the user navigate to a folder location on their computer which is what the above code does, they need to somehow navigate to a location on Google Drive.
Can this even be done and if so has anyone done it before?