web query

Hello I am web querying data from a website to get data from quarterbacks. I am trying to create a loop in vba that will take a list of names and enter them into the URL so that I don't have to enter each name individually. I would like to compile the data into one long table of values. The...

i am upgrading a excel spreadsheet database in to a relational database in access but am kind of stuck i need to enter the moves each pokemon can learn at the appropriate level but there are now 649 of the little blighters so thats a lot of moves is there a way of importing the data from...

I have a spreadsheet with film titles. For each film I would like to include a short description and rating from Rotten Tomatoes. Doing this manually would be long-winded and mean ratings aren't updated automatically. How can I do this using a web query? The blurb on the Tomatometer panel and...

I am trying to bring in data from the web (works) and as is, Excel overwrites the old data with the new. How can I set it up such the Excel brings in the new data and does not overwrite the old?

Hello all, I am using a web query to pull some data with the following structure: Row132: Header 1 Rows133-200: Data set 1 Row201: Header 2 Rows201-300: Data set 2 I would like to separate the data sets into 2 different sheets. The problems i am facing: - Data is dynamic - Header 1...

Hi, I have a web query which used to work fine but has stopped doing so recently. It was set-up to copy the whole of a webpage from BetExplorer so I could get the football odds but now when I run it, all of the numbers underneath the 1,X,2 do not appear in excel. Does anyone know what that...

I am trying to import a table from a website just simply using the 'Data from web' function in Excel 2010 which seems to run fine but no data is actually shown in the worksheet even after the 'getting data......' has finished running. The website I am looking at is...

Hello - I am creating a tool that many people will be using. I need a way to do the following from vba: 1. Click on the "From Web" button under Get External Data section in Data and show the web query pop-up 2. Input the url into the field and press enter At this point, it will be the user's...

Hello, I'm working on a project in VBA for Excel and the web. The goal is to trawl a college's Business School directory for a list of professors and their contact information. Once the data is collected I need to write a loop that will go through all of the individuals and paste their...

Having trouble with a web query that looks up historical stock prices through Google Finance. The code works for some stocks, but then it errors out for other stocks. When you manually type the stock ticker into Google or manually create the URL link (in Word, for example), it works just fine...

Thanks for looking -- I'm trying to create an excel worksheet that will query a website that requires login credentials, but the kicker and what I'm having the most trouble with, is actually creating a log/database of the data retrieved by excel. Goal: To see the time trends by creating a...

Hello, I have a web query that extracts data to a worksheet. Part of this data contains phone numbers which could be in any international format. What seems to be happening is that if the phone number contains any operator sign (+, - etc), Excel seems to be converting this data to a formula and...

I am a cricket buff and like to see statistics. But they run to 47 pages running to 9,394 rows in a website. Copy and paste is not a solution. I look forward to your help in either developing an Excel VBA macro or any other way. Please see the first two pages here: Page 1...

Here's the problem I'm having I want to pull web queries for a specific data table for a list of APN# Which is in column C under the tab I labeled "Orange" for example APN 29621305 12341234 23454322 The url which i am trying to pull data from is static with the exception of the "29621305"...

I have a macro that imports data from the web and puts it into four different columns- A, H, O, and V. I'd like to space the web data out over 7 columns (so from A through G for the first column of data, H through N for the second column of data, and so on). When I tried using this piece of code...

Hello, I have recently tried to use the Web Query Wizard in Excel and got this error: "This web query returned no data. To change the query, click OK, click arrow on the name box in the formula bar, click the name of the external data range for the Web query, right-click the selection, and...

Hi, I have a VBA program that pulls messages out of another system (that posts messages on our intranet within HTML code) and processes them further in an Excel program. We have used this for several months with everything working great, until we figured out that Excel was ignoring text within...

Hi everyone! I want to have a webquery that pulls figures from a url in a cell. I was thinking it might be possible to do this using a string but I cant seem to get it to work. Can anyone help me please? With Selection.QueryTable .Connection = "INSERT STRING HERE"...

Hi Here's what I'm trying to achieve: Have a workbook that I'd like to have locked down and use a web query tied to perhaps a workbook open event and store a temp file on the users computer to indicate when it was last opened and tie into it, by the calendar date, of lets say, 30 days to allow...

Hello! I've been working as a volunteer for a political group in Washington state and have been trying to write a script that would fetch the voting districts for each address in a table. Normally this would be fairly easy, but when you search for an address in here...