Hi I'm following this video as I'm trying to have a live API feed into excel.
I've used my API key for the data that I need but when I follow the formula from 5.31 onwards I get a Compile Error on the 'Req.Open line'
Here is my code:
Private Sub Btn1_click()
Dim Req as New XMLHTTP
Req.open 'GET','API Key here'
I'm aiming to have the small bit of data in the APi key pulled through every time the refresh button is clicked. Currently my sheet just has a refresh button in and I'm trying to code it to automatically place the live data below it.
I'm a beginner here but can anyone help me understand why I'm getting the complie error or explain a simpler way to pull API data?