web query

Hi, I was wondering if anyone could help with this query. I have a worksheet that imports data from a website using a simple web query import. The thing is there are 3 different sections of the web address that I would like vba to replace each time based on text that is in Cells A2, B2 and D2...

Hi everyone, I hope someone can help me regarding something that has been puzzling me. I want to import the following page into Excel via a web query: BBC Sport - Football - Live Scores On the right side of this page there is a section titled 'As It Stands Table' which has a dropdown box...

Dear Sirs, I wander Whether it is possible to track history of data connection output results without VBA. For example, there is daily updated table in the internet in the format {date;value} It was loaded into Excel Data Table with help of web query. Each day on update of table old data...

Hey there, So I am trying to extract data using a basic web query to dump it into a garbage tab to refer to the data in other tabs. However, the websites I try to query demand me to specify a start and end date or to press a button. The URL does not change at all. This challenges me big...

Hello! I'm sure this is a stupid question etc... I've made a file that used a .iqy web query file to power the web query and to allow it to be customised based on the users choices. The query itself is as follows. WEB 1 http://["Web Address"] Selection=EntirePage Formatting=All...

Hi! I wish to do a datestamp on some thousand web queries, with the date the query last was updated/refreshed. Is there such a value to get, or do I need to do some sort of workaround?

I have this URL: And I need to retrieve data(C3 etc) from each of the quote's(several hundred cells in column A) corresponding webpages?

Hi guys, I am trying to download (publically available) data from the website: Phelix Futures I am using the web query method in excel: Data-> from Web For some reason it doesn't import the table with numbers in excel, just some text (which I don't require.) Can anybody help me to get...

Hello, Excel 2010 I have a web query that pulls data in XML format. If I run this query interactively, through the Data/Get External Data option, the XML is properly mapped into a table. I saved the query to a .iqy file. When the query is run via the file, no schema is applied. I went...

Good Afternoon, I have this information: A <colgroup><col><col><col></colgroup><tbody> 1 ISIN Name Sector CA1535011011 Central Fund Canada CL A CA44045F1190 Horizons Betapro Nymex Natur DE000A0HGZR1 IShares MSCI World UCITS DE000A0H0728 Ishares DJ-UBS SW DE000A0H0769 DJ...

I am trying to make an action house profit calculator for a game and I have all the data setup correctly to calculate profits and auto update values when new information is put in into the material cost page. I want to have the data updated from a website either automatically or when i manually...

Hi all, So I used the record macro to import a table, by web query. I then build a dynamic link, placed it in and altered the code around it. Then provided a basic loop to repeat it for each value in the dynamic range. The problem I'm having is that it creates the page, and connection but it...

Sorry if this is in the wrong place, I'm a first time poster. After a few guides I'm still having trouble doing what I set out to do. I'll start off with the basis on the spread sheet, so let's say in Excel, I have; <tbody> A B 1 Place BHX1 2 Date From 04/10/13 3 Time From 21:00:00...

Hi all! I'm new to the forum, and I'm trying to do a web query to import data from a web page. I'm on Excel 2010. This is the web page: Australia Box Office, September 5–8, 2013 I tried to do it through the Data > From Web> New Web Query method and selected the table but it returns the error...

Hello, I am new to macros, and to recording them. I created a webquery with a parameter that it edits a part of the query based on a cell I select. I now have to run this web query 800+ times. So I recorded myself doing it with the "Use relative references" checked. But it always puts the...

I need to copy some Olympics data from the Olympics website about Medal tally. The website is Medal Count - Olympic Results & Medalists | IOC , and i need to look for Medalists (the right hand side) By country and then by Olympics. This opens a new page with the following Columns (which i need...

Ok. Here is the skinny. I am using excel 2007. i am a mechanical engineer. I have dabble in macros along time ago. fairly sophisticated with arrays and using visual basic. but, that was a long time ago.... i seem to have forgotten most of the details and kind of starting from scratch...

Is there a way to access a zip file's contents through VBA? I'm hoping to avoid manually downloading the Fama French factors each month, and instead set up a web query or VBA routine to pull them into Excel. The data is on this web page: Kenneth R. French - Data Library And this is the...

I was looking for an answer to an Excel web query issue, and found a pseudo solution on an older thread (linked in trackback). The issue I'm having is retrieving data from an Excel web query, where the data on the web is dynamically obtained after the page has loaded. The result is an empty...

My web query has square brackets in it. When i put that in a macro its assuming it has parameters and asking for them when i run it. "empType=All+Employees&mgrUserId[]=All+Managers&shiftCode=All+Shifts&processId[]=1003027" here is a snippet. When i run it macro just thinking that i put...