Use Excel VBA to Read API Data скачать в хорошем качестве

Use Excel VBA to Read API Data

Learn how to write real-world Excel VBA code: 👉https://courses.excelmacromastery.com/ Want to download the source code for this video? Go here: https://bit.ly/3BRIe92 Subscribe to the channel here: https://bit.ly/36hpTCY Today I'm going to show you how to use Web API's with Excel VBA. Web APIs may seem a bit daunting at first but by the time you finish this video, you’ll be able to read data from any Web API with ease. The first part of the video explains the 3 core parts of dealing with Web APIs. It explains each in detail and provides coding examples. Don't miss the final part of the video where I show a simple method for writing the code for any API. All the code used in this video is available to download from the link in the description below. #VBAAPI #ExcelVBAAPI #VBAWebAPI #VBARequestAPI Free Excel VBA Resources Excel VBA Articles (https://excelmacromastery.com/vba-art...) Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + C OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9(or click left margin) Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Auto complete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *) To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y(note: this clears the clipboard) Table of Contents: 00:00 - Introduction 00:37 - What is an API? 04:37 - API Code example 07:41 - JSON Converter Library 09:27 - Reading the converted data 12:20 - Understanding the returned data 15:46 - Fast method to write any API code