web query

​Morning guys, I have looked through this and other forums but no code seems to be working for my website and keeps giving errors i am unsure of. Simply put i am trying to complete a web query to pull data from a table, this information is behind a login page for both username and password. I...

Hello All: I am working on a project with several thousands rows. I have the addresses for doctors in the state of Florida and need to find the Business Name of the address that is listed. I do not know if the best route is to use a web query or VBA code. The address are in the following format...

So here is my dilemma, I am attempting to make my Zip Code Workbook dynamic with a web query, but am missing something. I have two Worksheets: Worksheet 1- "Zip Codes" which has a complete list of every zip code in CA, with a "Command Button" inserted in with the goal to use a specific zip code...

I know it's been asked a hundred times. I've tried reading through posts and different informational links but frankly, I just don't get it. I'm trying to save the old data and add the new data to it when I do the refresh. I know I have to have an archive sheet, I think I might need a...

Hi all! I have access to a website that contains data on companies with a download to excel option. You search an id number or the company name in the site and then you can choose the data points you want and export to excel. Now I have 10s of thousands of these id numbers and am looking to...

Hi Everyone, I need your assistance as the title above. I'm extracting a data from a website to an excel sheet. I can easily do so if loading the entire page or specifying a web table. But for a particular web site, there is this data that I can only extract if I use "Entire Page". Is there...

Hi I want to make a web query that copy this page: ipad | eBay in column A from A1. Than I want to copy the "next page": ipad | eBay in column A from A1001. Than I want to copy the "next page": ipad | eBay in column A from A2001 etc... I try this code but it doesnt work :( Sub Macro1() ' '...

Hello, I am trying to get an Excel web query to not create a new connection but to change focus to an existing IE connection. Any suggestions greatly appreciated.

hello there, I have stumbled upon the following problem: web query (current currency rate) -> data are put in decimals with period -> I can't use this data for further computing how to change the data to numbers with comma? I want to keep the data fresh, so it automatically refresh from time...

I need help. I am running a simple web query: https://finance.yahoo.com/q/cf?s=AAC. The query return the cash flow statement for the stock symbol AAC. The query accurately gives me the cash flow statement, but places a dash “-“ for all zeros. The dash is accurate when compared to the actual...

Thank you all in advance, I have a worksheet that includes a dynamic web query. There are 3 inputs: a year, a location ID, and a statistic ID that are all part of their own data validation range. Currently, every time I change one of those inputs the web query updates. What I'd like to do is run...

I'm using Excel 2003 and 2010 and trying to import the main table from the following link:Nasdaq New Highs & Lows - Markets Data Center - WSJ.com The targeted table is labeled atop "New 52-Week Highs:" When I use the "New Web Query" menu function and insert the link, the first unusual...

This is essentially what I need to code to do: Clear Sheet X Find the first / next “Waiting” text in column 3 of the “Tracker” sheet Create a Query on Sheet X (in cell A1) with the address “http://efm/telecom/engineeringWorkOrders/viewEWOStatusLog.aspx?ewonumber=” + the corresponding # in...

I'm new to this forum. I have some experience with VBA but none with HTML or Javascript. I am trying to get excel to reference (and regularly refresh once a day) 5 different data tables from a single url of a website that changes the data depending on 5 different regions of a U.S. map. I tried a...

Hello! I've been working on this for what seems like days. Ultimately, I'm wanting to know how to quickly grab data from a link via Web Query, then edit that data with a script or macro. End goal is to identify fantasy football draft trends: Web Query: Completed Draft - Fantasy Football...

I am very new to VBA, and so any help the experienced Excel community could offer me would be greatly appreciated! In an Excel spreadsheet, I have a column list of 11,945 Google Scholar URLs for specific research articles in Google Scholar's database search. Most of these research articles...

the query given below wiil take part number from cell AA1 and import data to excel sheet. 404 - Not Found["PARTNO","Enter PartNumber"] I need to change web query such a way that it should take multiple part number from different cell and import data to same sheet. I tried this: 404 - Not...

How to login to enable web query in vba excel - Stack Overflow This person had a similar issue, but it wasn't really resolved. I'm hoping that the people at MrExcel would be able to help me out with this. I'm using a VBA macro to log into a website using InternetExplorer.Application. My issue...

Hey everybody, Background First post, as I've been able to answer many of my questions through the use of google. I'm working on a grade calculator/schedule for my college courses. It's a project that has evolved over two semesters so far, but I'm now at a road block. Question The website I'm...

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...