web query

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

    web query properties

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

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top