Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
query tables | Excel Programming | |||
SQL Query Destination as an array varable | Excel Programming | |||
Error: Number of query values and destination fields are not the s | Excel Worksheet Functions | |||
Refreshing Query Tables | Excel Programming | |||
Query Tables | Excel Programming |