Stack Overflow
Stack Overflow

Questions tagged [excel-web-query]

Excel Web Query, Internet Inquiry (IQY) - A Web query is a feature in Excel that allows you to retrieve data stored on an intranet, the Internet, or the World Wide Web.

A Web query is a feature in Excel that allows you to retrieve data stored on an intranet, the Internet, or the World Wide Web. A Web query can use static parameters, dynamic parameters, or a combination of both. Queries with static parameters send a query without any input by the user; queries with dynamic parameters prompt you for input. Regardless of the type of parameters in the query, the requested information is pulled from an Internet or intranet site, and the results are placed in a worksheet.

113 questions
28
votes
5 answers

Excel 2007 Pass-Through Windows Authentication

I've created a simple (asmx) web service which returns a DataSet. I've added the webservice to my Excel 2007 workbook using the Data -> From Web button and I'm able to view / refresh the data. The problem comes when I need to secure the web service:…
Nathan
  • 6,095
  • 2
  • 35
  • 61
13
votes
2 answers

getHTTP with (Excel) VBA?

I'm searching for a query for an Excel VBA macro to get a web page's HTML source code as a string. I've found some source with getHTTPrequest but I can't register .net framework system.dll or link it. Thanks!
seansilver
  • 435
  • 1
  • 6
  • 11
5
votes
2 answers

Refreshable Web Query using Excel 2010 and Parameters

I'm looking to pull into the XML feed from Feedburner's API. This is just a matter of writing the URL and using the "From Web" data connection in…
nathanziarek
  • 619
  • 1
  • 6
  • 16
5
votes
0 answers

Excel VBA Web-Query error saying cannot locate internet server or proxy server

So I've been doing quite a lot of "development" in excel vba (not really high class stuff) for my company and have been experiencing an issue I can't seem to solve. What the app does: QC's check for errors in customer boxes and then logs any found…
SL8R
  • 51
  • 3
4
votes
2 answers

SSIS: Programmatically create new Excel file based on web query results - how do I save the web query table names?

What am I trying to do? I have a list of URLs that I want to scrape using Excel's Web Query functionality. I'm trying to completely automate the process, so I'm developing an SSIS package that calls a Script Task for each URL. The Script Task…
digital.aaron
  • 5,435
  • 2
  • 24
  • 43
4
votes
2 answers

What do I need to do to make Excel access a Web Query via HTTPS?

I'm trying to implement a page that allows Excel users to use the data it provides via the Web Query feature provided by Excel. It's all working out pretty nicely, as long as I use HTTP (even BASIC user authentication works). As soon as I switch…
Joachim Sauer
  • 302,674
  • 57
  • 556
  • 614
3
votes
3 answers

Can I get the stream from an Excel VBA Web Query?

I am using Excel VBA's WebQuery, using something similar to this example: (This example is actually copy-pasted from here: http://support.microsoft.com/kb/213730 and I am using a different URL with different POST arguments) Sub…
Josh
  • 4,412
  • 7
  • 38
  • 41
3
votes
0 answers

Excel Web Query Does not refresh

Is there a way to get Excel 2007+ to refresh a web query automatically? Scenario : I create a spreadsheet. Select Data/From Web. Type in the address of a web service that I know returns a valid response, select the returned xml and the data appears…
yuben
  • 693
  • 1
  • 9
  • 23
3
votes
3 answers

Issues with My Web Query Macro

I wrote a Web Query macro to import financial statements from Yahoo Finance based on the value in cell A1. It was working seamlessly for the past few weeks, but suddenly, it no longer returns any data (but does not generate an error). If anyone has…
Michael Shore
  • 95
  • 2
  • 7
3
votes
3 answers

How to automate a web query login to download data in Microsoft Excel 2007?

Is there anyone that can share knowledge about how to automate a web query in Ms.Excel 2007 by starting a session automatically? My problem is that I need to manually login through a web query each time....
Wei84
  • 31
  • 1
  • 2
3
votes
1 answer

Excel 2013 VBA Web Query connection string containing variable

I am getting a Run-time error'1004' error on the following line. With ActiveSheet.QueryTables.add(Connection:=connstring, Destination:=Range("$b$2")) Destination:=Range("$b$1")) The Variable connstring seems to be causing the problem. How do I…
user3200885
  • 31
  • 1
  • 2
2
votes
1 answer

Excel VBA Pulling Web Data From a List of Hyperlinks

I have a list of hyperlinks in column C on sheet 1, and I want to pull data from each link and put the data for each link in separate worksheets which have already been created. All of the hyperlinks are to the same website...pro football…
Laymo
  • 43
  • 4
2
votes
1 answer

Can't refresh webquery in Excel 2016

Since a few weeks I am using Office 2016 and I have a few Excel spreadsheets that collect data from my own webservice using a web query. As you can see, the webservice has the right properties in the connections dialog: When I refresh, I always get…
Jelle Capenberghs
  • 794
  • 2
  • 14
  • 30
2
votes
0 answers

Adding credentials to Excel web query file

I have a file_name.iqy file which I am trying to open automatically within Excel 2016. The contents of the file are this: WEB 1 https://link goes here Selection=3 Formatting=Rich Text DisableRedirections=False I want to add my credentials into…
noc_coder
  • 349
  • 1
  • 15
2
votes
2 answers

excel powerquery replacevalues based on cell

I'm extracting data from a site using excel powerquery, the site is http://www.timeanddate.com/holidays/south-africa/2014 The web table presents dates in the format mmm dd so; Jan 01 Mar 20 Mar 21 ...etc. To get results for different years I can…
user2213361
  • 87
  • 9
1
2 3 4 5 6 7 8