Hey Devendra,
The issues is while using a sendkeys method procedure send the keys one by
one not once at that time. Therefore it is opening the compact controls of
Google spreadsheet without going into actual control. Looking for the
procedure which can process the keycombination at once :(.
O
Hi Mandeep,
I have tried to run this code & it running properly. Its opening the file
but unable to download the file because we have given the Keys to (*File
Menu+Download*) but there is another more options in- *Download As. *
So how we will handle this issue.
On Mon, Jan 4, 2016 at 3:31 PM,
Hi Mandeep,
Thanks for your prompt reply & The Google sheet which I have, contains more
than 20k rows & its a shared sheet. It requires a login name & id of my
organization domain. So how we will handle this.
& If a key combination can be added to download the data from web through
VBA
On Mon,
Hey Devendra,
Excel has option in Data tab and "From Web" option to import the data from
websites,I Tried and found that this Case doesn't work if your sheet
contains a lot of data and to fetch it will take a lot of time, Instead of
this what i think is to Download the file first and then use v
