Search results

found a way to get to the sheet you want! In my code, replaces the line starts with: .QueryTables.Add Connection:=.... with the following: .QueryTables.Add Connection:= _...

Thanx, If I understad correctly, you gave an answer for deleting rows in the local excel worksheet. If so, I wasn't clear enough - I'm talking about editing the google docs spreadsheet itself. The question is wether I can do one of the followings: 1. Send an http command that will delete rows...

I don't know how to read the second sheet. I'll be happy to hear ideas... A not-so-cleaver workaround would be to create a new spreadsheet that includes all the spreadsheets you have, and read it. For example, if you know that your spreadsheets has 10 rows and 5 columns, fill the appropriate...

With a lot of searching and adding together all kinds of code parts, I've managed to wirte a code that reads a google-doc spreadsheet into access! The google doc should be in semi-protected sharing - whoever has the link can view the document. For the example, I've made a form with the command...