+ Reply to Thread
Results 1 to 5 of 5

Google sheets vba 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 vba 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 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.
    Last edited by western; 01-14-2021 at 08:48 AM.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,798

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

    You cannot use VBA in Google Sheets. Also, there is a separate section for non-Excel related questions.
    Rory
    I drink, and I know things

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

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

    Dear Rorya,

    thank you for giving me a reply, will see if i can move the post to not excel related questions.
    In regard of not possible to use VBA in google sheets, i did not know. I was able to adjust the script below to work for other of my projects in google sheets could you tell me what script was this? as i could only adjust it as i learned basic knowledge of VBA XD.

    Thank you in advance

    Please Login or Register  to view this content.

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,798

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

    That's Javascript.

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

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

    Understood! thank you. will now delete this thread

+ 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] Download xlsm file from Google Drive
    By karmapala in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-19-2020, 10:29 AM
  2. 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
  3. google sheets check-boxes are not appearing in download file
    By Mofasol in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-26-2020, 01:02 AM
  4. google sheets check-boxes are not appearing in download file
    By Mofasol in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 01-26-2020, 01:02 AM
  5. 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
  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