Import data from ONE CELL from Google Spreadsheet Using VBA

Hello guys.

I need VBA to pull a single cell value from Google Spreadsheet using VBA. I have come up with this code right now below. But all it does it pulls me data worth of 100 rows. And this is how it looks like. Is there a way how i could return a value from goodle spreadsheet A1 cell a single value to my local file on a computer into the cell A1?

2.JPG

Please Login or Register  to view this content.

No if you import it as a table. I do not think it is possible to just export a single row with in a table. However, if you use a different method (Either IE or HTTP object), you can loop through a table or just extract a single cell. This probably requires log-in in to your account which no one (Except you) can access it.