Importing data using VBA into excel from Google Spreadsheet

Hey guys,

I want to import data into an excel Sheet from a Google Spreadsheet page than has all privileges to be edited and viewed. The test link is below :


https://docs.google.com/spreadsheets...it?usp=sharing

I’ve tried several methods such as “Query and Connections” or Extract Data from Web but nothing seems to work.

Did anybody tried or found a solution for this kind of connection ? (It can be copy paste sheet , that would be good too)

Thank you,
Alex

Use a get data from web pointed at:

Please Login or Register  to view this content.

Quick Question : How did you generate that link to the direct sheet? Where i can found the rules (if there are any)?

From SO: https://stackoverflow.com/questions/...ultiple-sheets

To download a specific sheet as a CSV file, replace {key} with the document's ID and {sheet_name} with the name of the sheet to export:

https://docs.google.com/spreadsheets/d/{key}/gviz/tq?tqx=out:csv&sheet={sheet_name}

The datasource protocol is quite flexible. Various other options include:

Response Format: Options include tqx=out:csv (CSV format), tqx=out:html (HTML table), and tqx=out:json (JSON data).

Export part of a sheet: Supply the range={range} option, where the range can be any valid range specifier, e.g. A1:C99 or B2:F.

Execute a SQL query: Supply the tq={query} option, such as tq=SELECT a, b, (d+e)*2 WHERE c < 100 AND x = 'yes'.

Export textual data: Supply the headers=0 option in case your fields contain textual data, otherwise they might be cut out during export.