VBA code to import more than 100 rows of data from google spreadsheet

**UPA** · 11-03-2017, 12:03 AM

Hi All,

I am trying to pull data from google spredsheet to excel using web query.i am only able to pull up to the first 100 rows of data, then errors out.
Please help me how to fix that.
Below is the code which i have used.

Please Login or Register  to view this content.

**UPA** · 11-03-2017, 07:36 AM

bump pls, can somebody help.

**kev_** · 11-03-2017, 07:59 AM

You are very impatient

You have bumped in less than 8 hours
Not everyone is on the same time zone as you
If I was in a big hurry I would hire a consultant....

VBA code to import more than 100 rows of data from google spreadsheet

LinkBack

Thread Tools

Rate This Thread

Display

VBA code to import more than 100 rows of data from google spreadsheet

Re: VBA code to import more than 100 rows of data from google spreadsheet

Re: VBA code to import more than 100 rows of data from google spreadsheet

Thread Information

Users Browsing this Thread

Similar Threads

Converting vba code into google spreadsheet script:dynamic dropdownlist

Import data from Google Spreadsheet to Excel

Import data from ONE CELL from Google Spreadsheet Using VBA

[SOLVED] How to import data from google spreadsheet?

discrepancy between Excel and Google spreadsheet import

google spreadsheet need function/code to pull data from one sheet to another

Cannot import more than 200 Rows from Google Spreadsheets into Excel

Bookmarks

Bookmarks

Posting Permissions