web query

HI, What i am trying to do is i am downloading the data to excel sheet from below mentioned website for the company from different tabs mentioned on the website i.e :License Details , Addresses, Responsible officers and so on. There are 1200 companies for which i want to download the data...

As part of updatting our computer equipment I was reassigned from a Dualcore Windows XP Sp2 with Office 2007 to a new Quadcore Windows XP Sp3 with Office 2010. Both with IE8. The problem at hand is this particular Macro that is run monthly and creates 167 web querys, one at a time. This is why...

Hi there, I am trying to run your tip "Refresh Web Data into Excel Every Minute" from 10/10/2005and I am having problems (Excel 2010, Win 7). Using the URL from the tip (not from the download): http://finance.yahoo.com/q/cq?d=v1&s=MSFT%2c+GOOG%2c+KO%2c+INTC and inserting it into a web query I...

Hi, I am using excel to do a webquery on some data through web. i was doing it earlier with ease.. but recently i noticed that there is a small ad in the middle of the data i want to do web query.. so because of that the whole table which had a small arrow on the middle left corner (right next...

My spreadsheet has films and related info, laid out in standard columnar layout - one row per film, data (director, year, etc.) in columns. I would like to populate the "Blurb" column with info from an external web site, e.g. the storyline section on IMDb. Is there any way of running a query...

Hello, I found a nice Statistics site I would like to use for my Fantasy Football league. It has all the stats for each week and position selectable from a drop down menu on the webpage. I recorded and altered a macro that will run through the numbers 1-16 for the weeks of play. I then...

In Microsoft Excel 2010 how can you get a web query to refresh into the next column instead of the same cell? I'm trying to track the price of a share of stock by date and would like the fields to update themselves every single day. I've tried different things including writing out a seemingly...

Hi, I'm trying to use Zoho CRM's API to suck data directly into Excel using a web query. The data comes in XML format. When I pull the data into Excel, it comes like this: uri no FL val /crm/private/xml/Leads/getCVRecords 1 *the actual...

Good Morning, I am attempting to set up data web queries from the following web sites but I am unable to do so. I believe it may due to the way the internet site has its data tables set up on their webpage but I am not certain. Any insight as to how I can get these tables set up as a...

I am interested in downloading data from a website and having it automatically update in excel - I have tried a web query but it doesn't recognize the table. Here is the website: https://www.midwestiso.org/RTD/ExPostLMPTable/ExPostLMPTable.html Please help!

I'm new to Mr. Excel, but it looks like a great forum. Thanks in advance for your help. Using Excel 2007, I've set up a data query pointing at the following Japanese newspaper website: http://www.asahi.com/international/list2.html I selected full HTML formatting in the Web Query Options so...

Hi all, I am trying to using a web query to pull data into excel, the data source I am using constantly updates, meaning the size of the table changes (rows can be added or deleted) is there a way to account for changing table size when performing my web query?

Hello everyone, I have some problems on Yahoo web queries. If I try to do a web query by entering the http, then it is ok, I can select relevant table and extract it. For example: http://finance.yahoo.com/q?s=0001.HK&ql=0 If I want to introduce a parameter into the http, like ["num"], then I...

Hello, I am trying to build a database of basketball player stats by using boxscores. I have built a page the list all the games on a particular day and I'm looking to build a macro that will allow me to pull the boxscore table of all the games played on a date specified. I was thinking I...

I have developed an interactive application that uses web query to send and receive data with a web site (a LAMP stack) protected with basic authentication. On my primary platform, Excel 2004 (Mac), everything works fine. The first web query automatically (i.e., Excel does this, not my code)...

Hi, I have a list of 200 URLs (all the same domain) in Sheet 1, A1:A200. I want a macro to make a new web query in Sheet 2, then store the value of H6 of Sheet 2 in B1:B200 of sheet 1. Any ideas? Thanks.

Hello. I am trying to do a web query for specific data on a web page that is within a table that changes each time the webpage is modified. The order of the table I need is not the same for each web query I do. For example, the data I need will be in WebTables = "4" for one page but be on...

Hi I can not speak English. So, I use a translator. My country, this issue could be resolved. So here is the question. My problem is the 'Web query'. 'Excel Basic Web query Maker' was not possible. So, 'VBA' must make. I'll explain with pictures. 1. Target webpage...

Hello! I am trying to obtain some cost of living information from bankrate.com by using a web query to extract it into excel. I cannot seem to get the query to return anything other than the original parameters that load automatically in the webpage. The actual webpage in my query is...

I have to pull several Web Queries in a workbook, all come from a website that requires login before I can access the urls. Here is my code I made to login to the website through Internet Explorer: Sub connectToScantron() Dim objIE As Object Dim objCollection As Object Dim objElement...