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.