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 • 17

  • Hữu Duy Đỗ
    Hữu Duy Đỗ 26 days ago

    Please, The download link has failed, please update the new Link, and let me ask for the code. Thank!

  • Rowan Ball
    Rowan Ball Month ago

    Hello, I get a run time error when I run this:
    this is on the line objWebcon,Send (ShtUrl)
    is there a solution for this please?

  • Mahboob Alam
    Mahboob Alam 2 months ago

    i am getting issues when execute your codes but i have already access.Request can you please help me what am i missing
    run-time error '-2147024891 (80070005)':
    Access is denied.

  • Navneet Soni
    Navneet Soni 2 months 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 2 months ago

    I am getting error please give correct codes

  • Pratik Parmar
    Pratik Parmar 5 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 7 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 8 months ago

    Thanks for sharing the codes its wonderful.

  • Kamlakar Shedge
    Kamlakar Shedge 9 months ago

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

  • vijayant duhan
    vijayant duhan Year 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 Year 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 Year ago +1

    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.