web api

Hi, I'd like to be able to update the data from the web based on a cell URL link. The reason for this is if you look at the example below there is a specific date, this date will change over time (as only require a certain amount of history, say 1 year). So ideally the web lookup would be...

There is a CSV data source online that publishes the latest data on COVID-19 cases in Austria. COVID-19: Überblick - data.gv.at The CSV file consists of one row with the latest number (cases, recovered, hospitalized, deaths, etc). I connected the data to an Excel file as a data connection...

hi, So I have this excel file made by developer. It's quite complex and has a scraping procedure. I have two copies of it, one at home and one at work - I was wondering if you could recommend me any online services to deploy this file and use it as Web App instead? I know it's possible but...

Hi all, I'm currently working on a series of UDFs (user defined functions) in VBA. What the code basically does is e.g. pick up a daily stock rate from Yahoo Finance. So I created a function named DAILY_STOCK_RATE. It works like this: DAILY_STOCK_RATE(stockcode,date,"OPEN"), which will pull in...

Good morning all, Im in a real pickle and in need of some help from some experts out there, Im trying to get a web API through vb(done) then get the data from it into cells. The data is returned in JSON, which is where im stuck. Its basically a Q&A database, each question has a ref no...