PDA

View Full Version : How do you run multiple web queries in Excel 2003?


RobertM
10-13-2005, 04:17 PM
I am trying to run a web query that will display results from different tables within a web site, all on one spreadsheet in Excel. So, how can I join two or more queries together, so I don't have to run them separately? Here is an example web query code (items in red are the only variable).

WEB
1
http://jesharepoint.jecsi.com/admin/AR/_vti_bin/owssvr.dll?XMLDATA=1&List={3A465C2E-D830-4083-9C16-2F6DD0923A90}&View={33CE7516-6CC6-4B51-B42A-4E0A890AA5BB}&RowLimit=0&RootFolder=%2fadmin%2fAR%2fInvoices%2f220L

Selection={3A465C2E-D830-4083-9C16-2F6DD0923A90}-{33CE7516-6CC6-4B51-B42A-4E0A890AA5BB}
EditWebPage=http://jesharepoint.jecsi.com/admin/AR/Invoices/Forms/AllItems.aspx?RootFolder=%2fadmin%2fAR%2fInvoices%2f220L&View=%7b33CE7516%2d6CC6%2d4B51%2dB42A%2d4E0A890AA5BB%7d
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
SharePointApplication=http://jesharepoint.jecsi.com/admin/AR/_vti_bin
SharePointListView={33CE7516-6CC6-4B51-B42A-4E0A890AA5BB}
SharePointListName={3A465C2E-D830-4083-9C16-2F6DD0923A90}
RootFolder=/admin/AR/Invoices/220L