[EN] Excel: How To Fetch Data From Internet via API

We used the VBA-JSON library to parse Json data with VBA.

We added the Microsoft Scripting Runtime library to our project in order to perform the operations correctly.

We have taken our data from Excel ranges for our system to operate on variables such as day / source currency / target currency.

#excel #exceltutorial #excelvideoları #vba #excelvba #json

What is VBA. VBA stands for Visual Basic for Applications. We use VBA to extend capabilities of Excel. In order to do this, we write codes inside Excel. As you can guess the programming language will be Visual Basic. We integrate both Excel and Visual Basic via some libraries. Thus we can access Excel application components from VB. So we can add, modify data or change styles or more complex jobs on Excel application.