multiple web queries in one worksheet? "jmessamore[ at ]roarkcapital.com" <jbmessamore[ at ]gmail.com> 26.06.2006 15:47:03 i have generated 4000 .iqy files which query a specific table on a website. when i run an individual query, the data i want is extracted perfectly. i need to be able to combine all these queries into one worksheet and run them at once (or in batches of 500 or whatever number necessary not to overload the connection). it would be possible to narrow my query down to just one or items within the target table, but for now i'd like to extract everything. have any ideas? with what i have now, it creates a new workbook for each query. i have put together a macro that takes all open workbooks and combines them into one, but it still takes too long because i have to click ok to each query before excel will search. a side question, therefore, is how can i suppress the dialog that comes up before excel will perform the web query. changing the macro security in excel does not solve the problem. please let me know if you have any suggestions or perhaps if another approach would be better. here is the query: WEB 1 http://134.186.208.228/caleasi/search.asp?TASKNAME=xshowDocs&PackageID=100773 Selection=9 Formatting=All PreFormattedTextToColumns=True ConsecutiveDelimitersAsOne=True SingleBlockTextImport=True DisableDateRecognition=False DisableRedirections=True

Re: multiple web queries in one worksheet? "Don Guillett" <dguillett1[ at ]austin.rr.com> 26.06.2006 21:47:46 I do this sort of thing by using ONE url with a loop to change whatever variable>do the query with the macro>copy the info wherever desired>do the next one. NO iqy. Here's the basic idea. for each q in [mylist] ' http://134.186.208.228/caleasi/search.asp?TASKNAME=xshowDocs&PackageID=100773 http://134.186.208.228/caleasi/search.asp?TASKNAME=xshowDocs&PackageID=q next q -- Don Guillett SalesAid Software dguillett1[ at ]austin.rr.com "jmessamore[ at ]roarkcapital.com" <jbmessamore[ at ]gmail.com> wrote in message news:1151336823.316355.245830[ at ]u72g2000cwu.googlegroups.com... [Quoted Text] >i have generated 4000 .iqy files which query a specific table on a > website. when i run an individual query, the data i want is extracted > perfectly. i need to be able to combine all these queries into one > worksheet and run them at once (or in batches of 500 or whatever number > necessary not to overload the connection). it would be possible to > narrow my query down to just one or items within the target table, but > for now i'd like to extract everything. have any ideas? with what i > have now, it creates a new workbook for each query. i have put together > a macro that takes all open workbooks and combines them into one, but > it still takes too long because i have to click ok to each query before > excel will search. a side question, therefore, is how can i suppress > the dialog that comes up before excel will perform the web query. > changing the macro security in excel does not solve the problem. please > let me know if you have any suggestions or perhaps if another approach > would be better. > > here is the query: > > WEB > 1 > http://134.186.208.228/caleasi/search.asp?TASKNAME=xshowDocs&PackageID=100773 > > Selection=9 > Formatting=All > PreFormattedTextToColumns=True > ConsecutiveDelimitersAsOne=True > SingleBlockTextImport=True > DisableDateRecognition=False > DisableRedirections=True >