web query

  1. 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...
  2. 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?
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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!
  11. 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...
  12. 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...
  13. E

    web query properties

    Hi where can i found the properties of the built-in browser of the web query ? tnx eran
  14. 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?
  15. 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...
  16. 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...
  17. 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...
  18. C

    Save Old Data when doing Web Query Refresh

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

    VBA- Automate web query on password protected site

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

    Web Query - Loading Entire Page and excluding a WebTable

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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...