i8890321
03-21-2016, 06:16 AM
I have an Excel file as an database to store all the information of tons of Doc files.
The format like
Created by
Company
Type
File Path
Peter
Three.com
Input
C:\Database\A12asA.doc
John
Smartone
Output
C:\Database\fds123h35.doc
Mary
CMobile
Input
C:\Database\sdf45sd.doc
...
...
...
...
My vba script will open the files i currecntly selected. All the things are workong offline, locally. because i can tell the vba where exactly the files are.
But i want to further improve the code and put all my doc files onto the google drive. so that everyone got the database excel file with the vba script can get the selected doc online.
I know that each google files having a unique ID. but how can i get all the files ID (more than 1k files) from the google drive?
I searched a while on the next and i found some code to help me download the docs from the google drive if i got the IDs of the file.
The format like
Created by
Company
Type
File Path
Peter
Three.com
Input
C:\Database\A12asA.doc
John
Smartone
Output
C:\Database\fds123h35.doc
Mary
CMobile
Input
C:\Database\sdf45sd.doc
...
...
...
...
My vba script will open the files i currecntly selected. All the things are workong offline, locally. because i can tell the vba where exactly the files are.
But i want to further improve the code and put all my doc files onto the google drive. so that everyone got the database excel file with the vba script can get the selected doc online.
I know that each google files having a unique ID. but how can i get all the files ID (more than 1k files) from the google drive?
I searched a while on the next and i found some code to help me download the docs from the google drive if i got the IDs of the file.