web query

  1. A

    US Masters Live Query

    Was wondering has anyone a reliable source to Query the US Masters live scores but have them in day by day format? Running a little comp and wanted a reliable link, thanks in advance
  2. E

    VBA code to use a web query with the option to insert user name and password

    Hi I want to use the method of web query (Data-From web) and to get a vba code that can insert the user name + password to a url login page. I try but its not work for me. Need your help :) TNX
  3. P

    Extract Data from Web Query

    Hi Guys, So I have run a web Query using a .iqy text file which is pulling data from a popular cryptocurrency site called CoinMarketCap. I am using api links for individual coins in order to get there price is USD updated every minute to try and track in an excel ticker. An example of a url...
  4. M

    Maintain text qualifier while creating a Web Query on MAC

    There's a Web Query in my workbook created on Windows that doesn't work if the workbook is opened on MAC and results in an error if trying to refresh it via vba and does nothing otherwise. I came across a variant of the following code on stack overflow which works to import the data from the...
    • MoshiM
    • Thread
    • int64.type mac quotes; chr(34); vba type web query
    • Replies: 0
    • Forum: Excel Questions
  5. B

    Web Query

    Good morning all, I would like to know how to set up a web query using excel. what are the best and simplest ways to do this?
  6. P

    How to download this data in one excel file but in multiple sheets ?

    I am trying to pull Historical data for derivatives into excel and keep running into a wall. https://www.nseindia.com/products/content/derivatives/equities/historical_fo.htm This is the link from where I wish to download the data into excel. I can pull the CSV file individually from the...
  7. M

    Refreshing web query creates #N/A in referencing cells

    Hi, I have a worksheet with one tab that has a web query retrieving data from an online table and another tab that uses a series of formulas that start by referencing the tab with the web queries. The order of the formulas is as follows: web query --> cells referencing the table created by...
  8. M

    How to implement an online calculator into an excel workbook

    Hello I want to implement an online calculator from a webside into an excel document. https://icmphilly.com/ortho-applications/prosthetic-joint-infection-pji-risk-calculator/ I want to be able to set those parameters in the excel document and get the points and the risk from the calculator...
  9. C

    VBA syntax question for Dynamic Web Query

    I am trying to update a Macro that I recorded so that content from the lines in the spreadsheet will update the web query target but have run into a a few errors. I've sorted through several of them but the current issue is a Runtime error. The following is the code for my query: Sub...
  10. S

    Advanced JSON Data Query with Web API (URL parts?)

    Hello, I'm using a Web API to retrieve tables of JSON data successfully into my spreadsheet. In the Query Editor window, there's an "applied steps" sequential list, featuring the first step, "source". Source is the actual web URL of the API itself. The dialog box for source allows entry of the...
  11. ca.moazzam

    Refresh exchange rates from Bank of Canada site in Excel file?

    Hello all, Bank of Canada recently redesigned its website from which I used to pull daily exchange rates and now refreshing my file doesn't work any more. I now need to first specify the currencies I need along with my target date on the new site and then it displays the target rates. If I...
    • ca.moazzam
    • Thread
    • bank transactions exchange rates rates web query web query refresh
    • Replies: 0
    • Forum: Excel Questions
  12. R

    VBA taking values from cells question

    Hi there I have written a web query to fetch information from a web page containing company address details. Each company has its own sub-page with a predictable URL, such that I now have a list of these urls for each company in question and these are arranged into a single row on my...
  13. M

    Missing data from table (web query)

    Hello I need to get data from this webpage: FIBA LiveStats. What I want is the boxscore info (individual stats) for both teams. Problem is, I can't get it "from web". The tables that I get in return are blank or null. Is there any way to get that information? Thank you!
  14. D

    VBA for large volume of refreshable Web Queries with a delay between

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hey all, I have a workbook I’ve used for 4 years on a Win 7 machine running Excel 2013 and recently bought a new computer running Win 10 and Excel 2016. One of the worksheets has...
  15. B

    Formula changes to #REF when pulling data from a web query!

    Hi all, This is my first post - sorry if this has been answered before (I'm guessing it has). I have an excel workbook with multiple sheets. "Sheet A" pulls data from an MLB website via web query. This updates daily and I have no issues with the data being imported. On "Sheet B", I pull...
  16. E

    web query properties

    Hi where can i found the properties of the built-in browser of the web query ? tnx eran
  17. E

    Web query - online

    Hi I want a web query that will run automaticly every day. But not from my pc , i want it on the web (something like google sheets) Is there a solution?
  18. C

    VBA web Query with login page

    ​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...
  19. K

    Return Business Name from Address in Excel

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

    Help With Making Web Query Dynamic Using VBA

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

Watch MrExcel Video

Learn Excel - Changing Case in Excel: Lower, Upper, Proper: Podcast #1356

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top