 |
 | 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 / New Users / September 2006Web Query
Hello all I am new to Web Queries and my vb isn't much good either. I need to go to a specific page enter a string from a list into the search box on that web page and download the results into excel. I then need to go to the next string on the list and so on. I have managed to create a query that will download the first 10 results. What I would dearly love to do is get the next results and then load up the next string. A tall order but much gratitude to anyone that can help. Anthony Perhaps you could give us the url and exactly what you want. I do this for clients all the time where you create a macro with a looping variable to get web data. myurl=ddddd" & myvariable & "eeee  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Hello all > I am new to Web Queries and my vb isn't much good either. [quoted text clipped - 8 lines] > > Anthony Don The URL is http://www.bda-findadentist.org.uk/. I enter the first part of a postcode e.g. TN1. Many thanks for responding. Anthony > Perhaps you could give us the url and exactly what you want. I do this for > clients all the time where you create a macro with a looping variable to get [quoted text clipped - 17 lines] > > > > Anthony With xl2002, simply goto the url>enter the postcode>click find a dentist>right click in the resulting table>export to ms excel>record a macro>data>edit query>change the end of the url Don I inadvertently forgot to say that I was using Excel 97. I however managed to download all the hits for one postcode so now need to implement your insts on the inputbox/cell reference to create a loop and therefore complete the task. Thanks again for your help. Anthony > With xl2002, simply goto the url>enter the postcode>click find a > dentist>right click in the resulting table>export to ms excel>record a > macro>data>edit query>change the end of the url The kind of web query that I mentioned can be adapted to xl97. You are invited to send your workbook to my address below along with detailed instructions and I will see what I can do. SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Don > I inadvertently forgot to say that I was using Excel 97. [quoted text clipped - 28 lines] >> next string.>> > A tall order but much gratitude to anyone that can >> help.>> >>> > Anthony>> >> |
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.