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
1
vote
2 answers

Excel VBA web source code - how to extract multiple fields to one sheet

Good afternoon guys. In a follow up to a previous query which was very much solved by QHarr, I was wanting to run the solved query against multiple fields from the source code rather than just one. The URL I am using is:…
KSASteve
  • 57
  • 6
1
vote
1 answer

Excel 2013: Writing web query file to extract different values from website drop-down list

I am a complete beginner with coding so for the moment I am just trying to import data from websites into Excel 2013 using .iqy files to change the parameters of the queries and to try to understand the basics of the html language. I came across a…
Daniel Harris
  • 13
  • 4
1
vote
2 answers

Making VBA scraped Data update automatically

I Successfully wrote VBA to scrape Data from a webpage. Since the Data updates regularly, I would like it to update in my Excel Document as well. The Data I'm getting is the different Odds from All BookMakers listed. I tried the .refreshperiod…
Issy the kid
  • 15
  • 4
1
vote
0 answers

Excel Web Query Issues

I'm having troubles adding parameters to a Web Query that reads currency rates from an Excel cell. I need it to read it through the cell because the data needs to be updated constantly and the date formatting is different than the standard…
Nikolajs
  • 325
  • 1
  • 3
  • 17
1
vote
2 answers

Extract specific table part of the webpage in excel?

I am new in Excel VBA/Macro I need to grab the specific part of the page, not the full page. The bellow code works in complete page, but don't need the all parts of the page. Sub GrabOutStandingTable() With ActiveSheet.QueryTables.Add(Connection:=…
user176705
  • 13
  • 6
1
vote
1 answer

Importing data from multiple pages of a single website

I am new to VBA and have been facing a lot of trouble with figuring out how to pull data from the website boxofficemojo.com. I am trying to extract weekly data for the years 2010-2015. So i found a code that did something along the same lines and…
Gunpreet Singh
  • 13
  • 3
1
vote
1 answer

Get multiple tables in one Excel web query

I have am getting many tables from a web page to Excel using Web Queries. The tables in the web page are listed like this A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12 A13 A14 A15 A16 A17 B1 B2 B3 B4 B5 B6 B7 B8 B9 B10 B11 B12 B13 B14 B15 B16 B17 ... In…
g.e
  • 13
  • 7
1
vote
1 answer

Web query and excel

I've a situation here and I'm completely clueless how to go about it. Say, I have an excel column with a list of companies. I want to find if the companyA has the product "butter" by looking up the company's website ("companyA.com").…
lunchbox
  • 435
  • 1
  • 6
  • 13
1
vote
1 answer

Pull tabular data from multiple web pages into workbooks

I am trying to write a macro in VBA that will pull data tables a number of web pages into excel. A new workbook would be created for each web page/table. There is one table for each web page, and each page has the same layout. The url for each page…
user3767619
  • 11
  • 2
1
vote
1 answer

Excel VBA - passing username & password to Web Query connection

We have a web query on an Excel worksheet that goes to MoneyFacts (Moneyfacts website) for the latest Bond & ISA savings rates. The rates page requires a login by username and password before the rates page is shown (as it's a subscription…
Our Man in Bananas
  • 5,809
  • 21
  • 91
  • 148
1
vote
0 answers

Excel VBA QueryTables TEXT vs URL Connections

I have the following two pieces of code for extracting a large table from a web service, one for a URL connection: With ActiveSheet.QueryTables.Add(Connection:="URL;" & URL, Destination:=Cells(1,1)) .PostText = "" .RowNumbers = False …
BBaxter
  • 145
  • 2
  • 4
  • 12
1
vote
2 answers

Excel VBA importing CSV from a web service with post data

I have a web service that produces a large amount of CSV data, which I need to import into excel 2013. I have found the straightforward way to do this: With ActiveSheet.QueryTables.Add(Connection:="TEXT;" & URL, Destination:=Cells(1, 1)) …
BBaxter
  • 145
  • 2
  • 4
  • 12
1
vote
1 answer

CSS Formatting for Excel Web Query

I am having a hard time finding good documentation for this really handy feature of Excel. Please see the below code and jsFiddle for reference. This jsFiddle contains the following code: CSS body { font-family: calibri, san-serif;…
Malk
  • 11,855
  • 4
  • 33
  • 32
1
vote
1 answer

Excel Web Query Object and Cookies: Is there a better way?

I have a HTML web page at work that I want to query data from tables into excel 2007. This web page requires I sign on with a password. I sign in with my normal IE7 browser, then I go to DATA -> connections -> my connections and edit the query. This…
user2873219
1
vote
1 answer

VBA Cell Referenced Web Query

I have this code that is supposed to reference column "D" for the company name and perform a query at yahoo finance for the stock symbol. It works great some of the time, others instead of the stock symbol I get "adchoices". I am not sure what I am…
Roland Smith
  • 51
  • 1
  • 9
1 2
3
4 5 6 7 8