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
0
votes
2 answers

automating downloading a .iqy file and reading the data from it

I've a link where I need to download data which is in ".iqy" file and I need to read that for further cleaning. I'm able to do it manually by entering the link present(in 3rd line) in the file using con <- file("ABC1.iqy", "r", blocking = FALSE) …
kishore
  • 187
  • 4
  • 14
0
votes
2 answers

Web Query where there are multiple Frames

My goal is to scrape the source code of a web page. The site seems to have different Frames which is why my code won't work properly. I tried to modify a code which I found online which should solve the Frame issue. The following code creates an…
Andreas
  • 1
  • 1
0
votes
1 answer

Excel 2007 VBA error 1004 in web query "address of this site is not valid"

I am using the following code to get data from an html page that is stored from the web in a folder on my pc. I have used basically the same code in another module where it work perfectly, so I don't get why it does not work in this separate…
Volker Piasta
  • 87
  • 1
  • 11
0
votes
1 answer

Mac Excel web query not working

We use web queries to retrieve data in Excel for reporting purpose. These Web queries are working correctly in Excel 2007, 2010, 2013 and 2016. But when used in Mac Excel 2016 it fails. We perform these web queries using VBA and retrieve data…
R. Oosterholt
  • 7,720
  • 2
  • 53
  • 77
0
votes
1 answer

VBA: Array cell reference Mismatch error

UPDATED 3/30 So I adjusted the code and it runs error free now but the issue is that it does not pull the correct data. X basically starts with cell(X,1) and goes on from there. How do I link X to the selected listbox options in the array? OLD…
JasonDL
  • 127
  • 1
  • 2
  • 12
0
votes
1 answer

VBA Web query with login+password

Morning guys, Using already answered questions on here i am still unable to get any code to work for my particular site, unfortunately as it is an internal website i cannot share the actual site. The site is a .jsp login page could this be causing…
Ryan Carter
  • 11
  • 1
  • 4
0
votes
1 answer

Automatically run data connections in XLSM

I have an XLSM file which contains 2 Web Query connection. When I go to "Connections" in the "Data" tab I am presented with the two connections I have. For each of these I can edit some properties, one which says "Update every X minutes". I've set…
Linora
  • 10,418
  • 9
  • 38
  • 49
0
votes
1 answer

Excel Web query: Unable to pass username and password to Windows security Login

I am trying to automate few web queries for my company's website. The website is password secured and everytime the excel is opened, it asks for the UID and pwd via the windows security pop-up. Is there a way to pass the credentials to windows…
Renukadevi
  • 83
  • 1
  • 1
  • 6
0
votes
1 answer

Using excel query to get a substring of the xml data from a URL

I have the following table in excel where col1=movie ID, col2 = movie name. I'm trying to use excel web query to to get the production firm name of all the movies in my list. ID Movie Name tt1540741 A Single Shot (2013) tt4630158 A…
John C
  • 65
  • 6
0
votes
1 answer

Excel Web Query pulls only half of the table

I came across web queries option in excel just an hour ago, so please pardon my naivety. I am trying to pull a table from this page on BLS, however I am getting only first part of the table whereas I need only the second part of the table (or the…
Gaurav Singhal
  • 998
  • 2
  • 10
  • 25
0
votes
1 answer

How to get web data which can be opened from a specific website into a different tab in excel

I wont to pull data from a webpage on the basis of a criteria's into excel however I am unable to do so. Website from which I wont to pull data can be logged in only via another website and not by just url. For E.g. My site name is Elsc and to login…
Sanchi Sharma
  • 11
  • 3
0
votes
0 answers

Search a term in one cell on a specific website then return resulting URL

So I have very little experience with web queries in VBA. Currently, I have a column of gecodes that require a satellite image of the location. I want to use this website :http://google-maps.pro/satellite and search in the search bar, then return…
J.H
  • 181
  • 5
  • 14
0
votes
1 answer

Excel VBA Webquey creates new column

for example, following query will create a new column A and the data from A column will now be in Column B With ActiveSheet.QueryTables.Add(Connection:="URL;" & u, _ Destination:=Cells(14, 8)) .BackgroundQuery = True .TablesOnlyFromHTML =…
Jatin Gera
  • 814
  • 1
  • 11
  • 25
0
votes
1 answer

Querying a spreadsheet on Onedrive from Google Charts

I share an Excel spreadsheet with some colleagues via Onedrive but we don't have any Microsoft BI tools. I'd like to use the Google Charts API to query some data from this sheet and present it in the form of a bar chart. Ideally the chart would…
CymanSez
  • 15
  • 4
0
votes
3 answers

Basic Authentication with Excel VBA "WebQuery"?

In VBA I am trying to leverage WebQuery for a tool I am writing that retrieves financial data. I create a WebQuery with similar code to this: url = "URL;http://my.url.com/" With Worksheets("Sheet1").QueryTables.Add(Connection:=url,…
Josh
  • 4,412
  • 7
  • 38
  • 41
1 2 3 4 5
6
7 8