web query tables destination
 

I have a web query which imports data on a w/sheet range A1:I57,a part of
data which is invisible unless I scroll down.The query has 5 tables. Is it
possible to change destination of 2 or 3 tables in the web query ?. if
so..What changes to be done to the webquery ?.If not what other alternative
ways to change the destination of web query tables.

web query tables destination
 

More info including url and tables desired. Sometimes best to import the
whole table and use a FIND macro to extract what is desired to another
location.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TUNGANA KURMA RAJU" wrote in
message ...
I have a web query which imports data on a w/sheet range A1:I57,a part of
data which is invisible unless I scroll down.The query has 5 tables. Is it
possible to change destination of 2 or 3 tables in the web query ?. if
so..What changes to be done to the webquery ?.If not what other
alternative
ways to change the destination of web query tables.

web query tables destination
 

url is http://www.nse-india.com/marketinfo/...atch_nifty.jsp
I want tables 3,7,9,11,13.
As you said i tried the web query with a macro cut paste the tables which
are at the bottom of page.But the only probllem I am facing when I am
refreshing thro External data range tool bar(refresh or refresh All) the data
again occupying upto bottom.

"Don Guillett" wrote:


More info including url and tables desired. Sometimes best to import the
whole table and use a FIND macro to extract what is desired to another
location.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TUNGANA KURMA RAJU" wrote in
message ...
I have a web query which imports data on a w/sheet range A1:I57,a part of
data which is invisible unless I scroll down.The query has 5 tables. Is it
possible to change destination of 2 or 3 tables in the web query ?. if
so..What changes to be done to the webquery ?.If not what other
alternative
ways to change the destination of web query tables.

web query tables destination
 

If you like, send your workbook to my email below and I will take a look.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TUNGANA KURMA RAJU" wrote in
message ...
url is http://www.nse-india.com/marketinfo/...atch_nifty.jsp
I want tables 3,7,9,11,13.
As you said i tried the web query with a macro cut paste the tables which
are at the bottom of page.But the only probllem I am facing when I am
refreshing thro External data range tool bar(refresh or refresh All) the
data
again occupying upto bottom.

"Don Guillett" wrote:


More info including url and tables desired. Sometimes best to import the
whole table and use a FIND macro to extract what is desired to another
location.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TUNGANA KURMA RAJU" wrote
in
message ...
I have a web query which imports data on a w/sheet range A1:I57,a part
of
data which is invisible unless I scroll down.The query has 5 tables. Is
it
possible to change destination of 2 or 3 tables in the web query ?. if
so..What changes to be done to the webquery ?.If not what other
alternative
ways to change the destination of web query tables.