VBA to add data to Google Sheets or pull data from Google Sheets (1 Viewer)

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 05:27
Joined
Jul 9, 2003
Messages
13,221

VBA to add data to Google Sheets or pull data from Google Sheets​

 

Isaac

Lifelong Learner
Local time
Yesterday, 21:27
Joined
Mar 14, 2017
Messages
5,380
Does anyone know how to download data from Google sheets in an automated fashion with Excel 2010 (not 2013 an above, as many solutions seem to require), and without installing anything special or an api?

I thought I've used the simple method (sheets>publish to web>single sheet>csv) by Data > from Text in Excel with the published link from Google, but it does not seem to work and I am using 2010.

Is there anything missing in my assessment of the options that are out there?
 

Isaac

Lifelong Learner
Local time
Yesterday, 21:27
Joined
Mar 14, 2017
Messages
5,380
Ok, I got it worked out.

Doing a straight Data > From Web (or TXT) > paste link from Sheets......Did not work in my 2010 version, but then I installed the free Power Query add-in and it worked like a charm.

Solved. Thanks for looking : )
 

Users who are viewing this thread

Top Bottom