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
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
Hi Anthony, What exactly are you trying to accomplish here? I'm a marketeer not a developer, so my solution to a similar problem may be unnecessarily complicated. However: We had a user refreshing a local, on-premise spreadsheet with data from a sales cube that wouldn't load off-premise. I made a VBA macro that, when the sheet was refreshed and saved, saved a copy to a network folder accessible via FTP. I used MS Flow/Power Automate to look for any files updated in that folder, it would grab the file contents, and save it to Google Drive as a Google Sheet. In this particular case, we had to convert the Sheet to CSV using Apps Script, but it would probably be possible as well to save any changes back to the FTP like in your case. Again, it all depends on what exactly you're trying to accomplish, but even for non-developers, it's pretty easy to build a work-around these days. Safe!