Consulting

Results 1 to 4 of 4

Thread: Excel VBA ~ Google drive doc

  1. #1

    Excel VBA ~ Google drive doc

    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.

  2. #2

  3. #3
    Thanks for the reply! I want to make it clear in my google drive i got tons of doc files (in many sub folders).
    Some of the links you provided just help me to get one file ID only

    But inside this link

    I found the following code and i dont know what and where should i paste and try. please give me some noob guide and hints. thanks

    // Log the name and id of every file in the user's Drive
    function listFiles(){
    var files =DriveApp.getFiles();
    while( files.hasNext()){
    var file = files.next();
    Logger.log( file.getName()+' '+ file.getId());
    }
    }

  4. #4
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    for now, you will have to leave off the first part of links. Just start with the "www" part.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •