Description

VBA was considered a dead language until new functionalities and objects have been made available to enable data exchange between MSOffice products and the Web.Today VBA offers functions to send HTTP requests, receive HTTP responses and parse the final results using technologies and objects e.g. DOM, XML parsing, JSON parsing, XMLXPath, VBA Regular Expressions, ADODBconnections to SQLServer and mySQL Databases, generate Web Browsers to embed into VBA forms and much more.Before into details I have included some lectures for those that are new to understand and get to know Excel, Visual Basic for Applications (VBA) and HTML.The students will learn the following in this course:HTMLDOMHTMLediting toolsOpen a Web page in VBACreate HTML Tables with from Excel Worksheets with VBA Create HTML Files with a Table of Contents based on Cell DataDownload File from Website Using ExcelScraping data from website using vbaGet data in an HTML table and display in an Excel fileGet all the data in an HTML table and display in an Excel fileVBA Code To extract data From website to Excel Macro with ServerXMLHTTPScraping a website HTML in VBA using the HTMLDocument objectRead data from a website using VBA web queryImport Website data to ExcelEmbed a browser in an Excel VBA formIdentify information on a Web Page and display it in human readable wayProcessing human friendly messagesGenerate machine-friendly messagesImport JSON to ExcelImport an XML file into ExcelGet data from the webUse the InternetExplorer Object to get Data from the WebUse the InternetExplorer object to get elements of an HTMLtableRetrieve single HTML elements using the InternetExplorer objectParse and submit an HTML form using the InternetExplorer objectTrigger events of elements using the InternetExplorer objectClick on a button and trigger the associated event using the InternetExplorer objectEnter data dynamically into an HTMLform using the InternetExplorer objectUse XMLHttp to send HTTP requests, receive HTTP responses and parse the contentUse ServerXMLHttp to send HTTP requests, receive HTTP responses and parse the contentUsing ServerXMLHTTP to GET XML results from a Web pageUsing ServerXMLHTTP to POST XML to a Web pageProviding authentication info via msxml2.ServerXMLHTTP (use JustGiving API)Scrape html by element id, name after response using msxml2.ServerXMLHTTPSave MSXML2.ServerXMLHTTP Response text is an HTML PageExtracting data from the response of a serverXMLHTTP requestExtract a table of data from a website using a VBA queryPull data into Microsoft Excel with Web queriesImport HTML content in Excel with Query TablesImport HTML table with Web QueryInvoke a SOAP Web Service from custom VBA CodeDo a SOAP Request in VBAUse VBA to send XML to WSDLCreate a SOAP Request/Response using XML from VBAGet Http Request In Excel VbaBuild a VBA App from calling an APIMake REST call with VBA in Excel: WinHttpSend HTTP requests with VBA from Excel with WinHttpGet Http Request In Excel Vba with WinHttpGet JSON Response with WinHTTP in VBAInstall and configure SQL Express Server and the Management tool for testingConnect to a remote SQL Server DB With VBA & ADODBUse Excel VBA to Query a SQL Server DatabaseInstall and configure a mySQL Database for testingConnect to remote MySQL DatabaseConnect to MySQL database in Excel with VBA and get the dataSend HTML Email from Excel using VBAShow RSS Feeds in ExcelRead RSS feeds from VBA create an rss feed with Excel VBAGet Data from Bing Search and display the results using DOMDisplay google maps on a UserFormCalculate durations and distances of itineraries from Google Maps with VBARetrieve Address Geocoding with VBA and Google MapsParse strings from HTML code via VBA code using RegEx…