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
2
votes
1 answer

Create Query table based on cell value

I want the macro to run from top to bottom on column C (on Sheet "Tracker") to find any cells that match the "Waiting", "Deferred", "New", or "Pending" text. Each time it finds a match I want to run a web query on Sheet "X" with the…
VladM
  • 23
  • 2
2
votes
0 answers

Is it possible to show Edit Web Query window when the workbook is opened in excel

We have a url say: http://www.example.com/myexcelbigdata/data.aspx which requires authentication. We want our users to be able to access this page via excel by using web query. If I add the url as web query, it will be redirected to the login page…
daxu
  • 3,514
  • 5
  • 38
  • 76
2
votes
6 answers

Excel 2002 Web Query screwing up en-GB dates

Good afternoon, I have a web query in Excel 2002 going against a web page that returns a date column. The dates are returned as DD/MM/YYYY, as I would like to show them in my spreadsheet. My machine running Excel has its regional settings set to…
AlanR
  • 1,162
  • 4
  • 14
  • 26
2
votes
0 answers

Excel web query escape characters for parameters

I am trying to load a table data into excel using web query. The URL used has special characters in the parameter names. Have tried using the encoded values of the characters but still no luck in opening the iqy file in excel. Throws invalid file…
Gaurav S
  • 999
  • 8
  • 16
2
votes
0 answers

How to load CSV data into Excel 2013 using https with basic authentication?

To do so, I wrote the following VBA script and bound it a button which sets some parameters and loads the data. Afterwards it removes the connection to avoid a pile of stale connections. Private Sub LoadData_Click() Dim ConnString As String …
Gerrit Griebel
  • 405
  • 3
  • 10
2
votes
1 answer

My Web Query works in Excel but not with VBA

I can run the Web Query from excel spreadsheet but when I put into VBA then it gets no data. Here is what a row of data looks like and the date is all in one column. The date has a quote in front that I want to remove but I will do it within VBA if…
RoseAb
  • 133
  • 1
  • 5
2
votes
1 answer

Create dynamic url using value from cell

I am running a web query for an Excel sheet and have been able to pull data correctly however I want to reference a cell that can be changed in the worksheet. Ex. I want to make the F reference a cell so I can easily change the request without…
user2740589
  • 21
  • 1
  • 1
  • 2
2
votes
3 answers

How to create web query on Mac Excel 2011?

I am trying to import data from a website on my worksheet, but when I click on import data from a new database query, it shows an error of saying: " Microsoft Query is not installed" I have searched every where but could not find the solution.…
user2413421
  • 113
  • 1
  • 2
  • 8
2
votes
0 answers

Excel web query 404 not found for site that exists

I am trying to use Excel 2010 to get web data using the Get External Data > From Web Excel is able to download data from (just checking the top left box to get the whole page) http://accuscore.com/fantasy-sports/nfl-fantasy-sports/ but when you…
mattyd
  • 1,643
  • 2
  • 17
  • 26
2
votes
0 answers

Excel web query output control

Excel for Mac 2011 Version 14.2.4 (120824) Mac OS X 10.6.8 This web query file WEB 1 http://finance.yahoo.com/d/quotes.csv?s=SGOL&f=sn Returns this text into a spreadsheet cell. SGOL,"ETFS Physical Swi" What I would like to know is how to get the…
Beast Of Bodmin
  • 91
  • 1
  • 7
1
vote
1 answer

What are the options for a .iqy file?

I'm trying to understand the options for the .iqy file format. I'm trying to use it to feed CSV data from an external web source into Microsoft Excel but I'm not finding any canonical documentation to make sure that I'm doing it right. Note: I'm…
Airerr
  • 451
  • 4
  • 16
1
vote
1 answer

Referencing a cell value as a parameter in the URL in Excel's Data From Web function

Hi I'm trying to get some data from a website into a worksheet using Excel's Data -> From Web function. But I want the parameter of the url to be dynamic and reference that value from a cell in the worksheet. I'm attaching a screenshot too. Could…
BigArcade
  • 33
  • 5
1
vote
1 answer

Are there any Ruby on Rail Gems or Plug-ins that performs web queries

I need build in web query capability similar to what you can do in Excel for a project that I'm working on. Has anyone come across a gem, plug-in or application with this capability. Clarification: To clarify, the excel web query features that I'm…
Mutuelinvestor
  • 3,384
  • 10
  • 44
  • 75
1
vote
1 answer

Excel Web Query vs MSXML2.XMLHTTP60

I am trying to get data from the web. I tried two avenues in Excel VBA. Both work but yield different results and there is also a noticeable speed difference. The first method is using Excel Web Query tool. VBA code I obtained by recording a…
Marco_sbt
  • 309
  • 1
  • 12
1
vote
1 answer

HTML Webpage Query with Various Search Parameters

I am attempting to import data from a website that requires certain search parameters. There are a selection of about 5 options that is required on the website. I'm trying to build a script that will query the website, select specific search…
FayeReal
  • 11
  • 2
1
2
3 4 5 6 7 8