web query tables destination

[TUNGANA KURMA RAJU]

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.

 

[Don Guillett]

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.

 

[TUNGANA KURMA RAJU]

url is http://www.nse-india.com/marketinfo/indices/indexwatch_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]

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