How to Download Google Sheet using Excel VBA

  • Published on Nov 16, 2017
  • To Copy the Code Visit Below WebSite.
    To Get More Videos Like This Please Like, Share, Comment and Subscribe.
    If you need help in any excel VBA Topic please comment below.

Comments • 14

  • Navneet Soni
    Navneet Soni 6 days ago

    I want to import live data from Google sheet to excel sheet changes in Google sheet live data should also change in excel please help

  • Navneet Soni
    Navneet Soni 6 days ago

    I am getting error please give correct codes

  • Pratik Parmar
    Pratik Parmar 3 months ago

    This is nice and working successfully. IF I want to get a value from a single cell from spreadsheet to any VBA variable then what can be done.?? Please suggest.

  • Peter Casas
    Peter Casas 5 months ago

    This worked great but it only does one sheet. I have 10 google sheets in the same book or https. How can i do it to download them all?

  • Bhola Tiwari
    Bhola Tiwari 6 months ago

    Thanks for sharing the codes its wonderful.

  • Kamlakar Shedge
    Kamlakar Shedge 7 months ago

    Thanks, It was very helpful. I used this code in VFP

  • vijayant duhan
    vijayant duhan 10 months ago

    Hello Shakti, this is wonderful. i really appreciated your hardwork. thanks for sharing the knowledge. could you please also tell us how to upload the data from excel sheet to google spreadsheet through vba and the data should be pasted on below of the last row in google spread sheet in consolidation manner

  • Andre Neves
    Andre Neves 10 months ago

    I can use this script for a personal gmail user access but if I use a work Gmail account and we can only share docs with other work users, when the file comes into excel its all just funny code lines and lines of code.

    AMIT YADAV 11 months ago

    not worked ur link...
    plz suggest

  • Apliclor Water Solutions

    Wow! It is a very useful code. I also used it in MS Access and it works fine.
    Thank you for your kindness in sharing this code.

  • Guy Manova
    Guy Manova Year ago


  • Navtej Singh Siag

    thx ..very helpful.
    what if, if google sheet is password protected

  • viraj shirsat
    viraj shirsat Year ago

    What if there are multiple sheets on the google spreadsheet....???

    • Shakti Shahi
      Shakti Shahi  Year ago

      +viraj shirsat Remove the code &gid="value"
      Where value is the gid no
      By removing gid you will able to download the workbook with all sheets.