Compile Error: Argument not optional

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'

Req.send

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?

Many thanks

thanks, that helped, I'm now getting a 'Runtime Error - Automation error and unspecified error

Is using Visual Basic the best way to feed API key codes into excel? I've had a look at the SDK 2013 - will this help or make things easier?

Thanks

Does anyone know how to have a live API feed in excel?

Ok so the aim is to get the data below into Excel and have a button as the video in the first link does which automatically updates it when it refreshes.

The data required from the API key displayed in web browser:

Please Login or Register  to view this content.

And the code I'm using in Excel is:

Please Login or Register  to view this content.

*for privacy reasons I've hidden the API key and a few other things as they belong to my company.

I've referenced the XML v6.0 in tools-references in the Visual and copied the same actions done in the video from 5.31 until Req.Send.

I want to be able to have a live feed of various API's automatically updating in the simplest way possible. This video is the closest I've found so far.

The data above is Active Users of an app v Date. I want to be able to import all sorts of data like impressions, CPC, revenue, etc and have them all updating and recording data.

Many thanks,

Any ideas?

my apologies, I am actually using double quotes - that is the version before I changed it. Thanks though - any ideas why I'm still experiencing this problem?

O.K I'm a total beginner at Excel VBA programming so I'm following the steps set out in the Weather Forecast video at the start of the thread from 5.31 in. I've tried to just copy the code which I think I'll need in order to get the Data (active users v dates --- in post 7) to appear live in Excel when I click a refresh button as shown in the video.

Following the video instructions I've created the Button and then added this code into Visual Basic:

Please Login or Register  to view this content.

I've copied the code I think I need from the video just to have the data from the API key go into excel at the click of the refresh button.

I've just ran the code and there were no errors this time. So I'm assuming it's good. However it's not appearing in my workbook. If I want to click the refresh button and have the data appear in two parellel columns, one for dates and one for active users in B6 and C6 respectively, what do I need to add to the code to make it do that?

Thanks

Thanks, that's interesting. What code/formula did you use to get it to appear in Cells B7-D8? This is what I need to do with my formula... where should I insert the cells where I want the data to be pasted in my code above to get it like yours?

On a side note, it does seem to take ages to load when I click 'get weather'

Thanks, that's interesting. What code/formula did you use to get it to appear in Cells B7-D8? This is what I need to do with my formula... where should I insert the cells where I want the data to be pasted in my code above to get it like yours?

On a side note, it does seem to take ages to load when I click 'get weather'

Thanks, that's interesting. What code would I have to insert in my code above to get my API key for date and active users to appear in the cells like yours does in cells B7-D8?

On a side note, it does take a long time to load when I click 'Get Weather'

Thanks, that's really interesting. But how would I edit it for my data to come through on refresh? The data I need is in post 7 but where would I enter it into the code and where do I say what cell it goes into? Thanks