Retrieve Google Spreadsheet data via VBA for import into Excel/Access

[bobgott22]

I'm trying to figure out how to access certail tabs/cells in a Google Spreadsheet and copy that data into Excel or Access via VBA.

Not even sure where to start as the Google Docs API does not seem very friendly to VBA.


- Thanx
- Bob

 

[SkipVought]

If it is a spreadsheet in Googel, and not a download of a workbook, try Data > WEB query

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

That would be from Excel into a sheet.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[bobgott22]

Web query does not seem to work on a google spreadsheet into Office Excel 2010 .. or at least I can't get the Import Button to highlight when viewing a google excel document.

Do you think its possible to use the "link to data service" option in Access ( 2010 )?


- Thanx
- Bob

 

[SkipVought]

what is the link?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[bobgott22]

I'm attaching a screen shot from Access 2010 where one can request a data link.

By some wierd change .. can someone create a data link to google docs?




- Thanx
- Bob