 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / May 2008web 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. 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.  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com >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. 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. > 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 [quoted text clipped - 6 lines] > > alternative > > ways to change the destination of web query tables. If you like, send your workbook to my email below and I will take a look. SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > url is http://www.nse-india.com/marketinfo/indices/indexwatch_nifty.jsp > I want tables 3,7,9,11,13. [quoted text clipped - 16 lines] >> > alternative >> > ways to change the destination of web query tables. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.