+ Reply to Thread
Results 1 to 6 of 6

Google sheets script to download file and save it to google drive folder and use it's data

  1. #1
    Registered User
    Join Date
    05-18-2013
    Location
    holland
    MS-Off Ver
    Excel 2011
    Posts
    27

    Google sheets script to download file and save it to google drive folder and use it's data

    Hi,

    I am new to VBA and have some beginning knowledge of scripting but not good for now for what I want to do.
    So I was hoping to find someone who can help.

    so this the issue atm.

    I wont to download a CSV file from a specific address:
    https://www.xxxxxxxxxxxxxxxxx.nl/fee...px?language=nl

    I have for now hidden our site as we can not give out the CSV file to the public atm. anyway if you click it, you will get a CSV file with tables and data in it.
    What I am trying to make atm is that google sheets will download this file every night to a specific google drive location. later I will try to get other scripts to get the data of that file and paste its data inside google sheets.

    I want to do this so we do not have to manually update our stock from our warehouse.

    Thank you all in advance.

  2. #2
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,133

    Re: Google sheets script to download file and save it to google drive folder and use it's

    The script below will download a CSV file from a URL into your Google Drive.

    This may be a starting point for you ....

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-18-2013
    Location
    holland
    MS-Off Ver
    Excel 2011
    Posts
    27

    Re: Google sheets script to download file and save it to google drive folder and use it's

    Dear Haluk,

    Thank you for your response, i already got a start, but trying got it to a specific folder now.
    This is the code what i use atm that works to download the file:
    Please Login or Register  to view this content.
    The link is fake if you place your https link it should also work.

  4. #4
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,133

    Re: Google sheets script to download file and save it to google drive folder and use it's

    After entering the folder ID in the below script, you can try it .....


    Please Login or Register  to view this content.


    And, as an alternative .... you may use the name of your folder instead of the ID of your folder, as in below script;

    Please Login or Register  to view this content.
    Last edited by Haluk; 01-18-2021 at 12:25 PM.

  5. #5
    Registered User
    Join Date
    05-18-2013
    Location
    holland
    MS-Off Ver
    Excel 2011
    Posts
    27

    Re: Google sheets script to download file and save it to google drive folder and use it's

    Dear Haluk,

    Thank you for your reply, this coded works perfectly thank you!

  6. #6
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,133

    Re: Google sheets script to download file and save it to google drive folder and use it's

    You are welcome,

    Drink a beer for me at the Hard Rock Cafe near the river in Amsterdam

    .
    Last edited by Haluk; 01-18-2021 at 01:38 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Google sheets vba to download file and save it to google drive folder and use it's data
    By western in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2021, 08:48 AM
  2. [SOLVED] Download xlsm file from Google Drive
    By karmapala in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-19-2020, 10:29 AM
  3. VBA download a file from on FTP and to uploaded to Google drive.
    By starlev in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2020, 05:34 AM
  4. Upload/download file from/to Google Drive (2)
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2019, 04:32 AM
  5. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  6. Upload/Download file to/from Google Drive
    By TudyBTH in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-08-2016, 07:22 PM
  7. File download from google drive and dropbox
    By patz006 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-26-2015, 10:02 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1