Access and Google Drive
I am using the following code to import XML files into an Access table:
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?
--Steve
Set fd = Application.FileDialog(msoFileDialogFilePicker)
With fd
.InitialFileName = "c:\sample\*.xml"
If .Show = -1 Then
For Each vrtSelectedItem In .SelectedItems
Application.ImportXML _
DataSource:=vrtSelectedItem, _
ImportOptions:=acStructureAndData
Next vrtSelectedItem
Else
End If
End With
Set fd = NothingThis 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?
--Steve
bas2754
Just a shot in the dark, but do they have the Google drive synching to their local computer, if so you should be able to just change the path. If you need to pull directly via the Web, I am not sure you will be able to do that with the basic version and someone more advanced than myself will need to point you to where to find the code for the API to do it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.