1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Using Excel VBA to retrieve and Update Google Spreadsheet

Discussion in 'Google API' started by anthonyrr, Oct 21, 2009.

  1. #1
    Guys need help with linking Google spreadsheet with excel.
    Basically i want to get google shared spreadsheet into excel using VBA and then update the doc and save back to google spreasheet using Excel VBA alone.
    How do I do this. Can you please provide a sample?

    Really appreciate you help. I have been trying the .NET code in the api sample code but going nowhere. It does not work with VS2008. even if i get it to work i dont know how this fits into VBA. I use VBA alot but am still a novice. Please do help
    SEMrush
     
    anthonyrr, Oct 21, 2009 IP
    SEMrush
  2. sava_here

    sava_here Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #2
    You can use VBA to retrieve and Update Google Spreadsheet via GSpread.NET.
    It opensource library works with Google Sheets by using Microsoft Excel API.
    Use CreateObject(GSpreadCOM.Application) instead of CreateObject(Excel.Application).
    see examples: http://scand.com/products/gspread/tutorial.html
     
    sava_here, Jun 27, 2016 IP