~Get Your Files Here !/1. Introduction/1. Course Structure.mp44.46MB
~Get Your Files Here !/1. Introduction/10. Manage cells and ranges with VBA.mp410.07MB
~Get Your Files Here !/1. Introduction/11. The VBA project structure and composition.mp47.3MB
~Get Your Files Here !/1. Introduction/12. The Worksheet Module Code.mp47.53MB
~Get Your Files Here !/1. Introduction/13. The Worksheet Properties.mp411.7MB
~Get Your Files Here !/1. Introduction/14. The Worksheet Methods.mp45.12MB
~Get Your Files Here !/1. Introduction/15. The General variables and subroutines.mp410.66MB
~Get Your Files Here !/1. Introduction/16. The Workbook Methods.mp47.54MB
~Get Your Files Here !/1. Introduction/17. Variables and Constants.mp45.13MB
~Get Your Files Here !/1. Introduction/18. Subroutines and Functions.mp47.36MB
~Get Your Files Here !/1. Introduction/19. User Defined Functions.mp43.56MB
~Get Your Files Here !/1. Introduction/2. Introduction to VBA.mp46.2MB
~Get Your Files Here !/1. Introduction/20. VBA Modules.mp46.65MB
~Get Your Files Here !/1. Introduction/21. The Worksheet Module.mp47.27MB
~Get Your Files Here !/1. Introduction/22. Public and Private Subroutines and Functions.mp419.4MB
~Get Your Files Here !/1. Introduction/23. Public and Private Variables.mp415.85MB
~Get Your Files Here !/1. Introduction/24. Variable Types and Declarations.mp46.81MB
~Get Your Files Here !/1. Introduction/3. The Developer Ribbon.mp411.22MB
~Get Your Files Here !/1. Introduction/4. VBE the VBA editor.mp418.14MB
~Get Your Files Here !/1. Introduction/5. What is a macro.mp46.79MB
~Get Your Files Here !/1. Introduction/6. Record a macro.mp414MB
~Get Your Files Here !/1. Introduction/7. Macro security.mp414.98MB
~Get Your Files Here !/1. Introduction/8. The workbook.mp47.29MB
~Get Your Files Here !/1. Introduction/9. The Worksheet.mp48.55MB
~Get Your Files Here !/10. Working with JSON files in VBA/1. The JSON libraries do not rewrite the code.mp48.78MB
~Get Your Files Here !/10. Working with JSON files in VBA/2. Import Json to excel.mp47.31MB
~Get Your Files Here !/10. Working with JSON files in VBA/3. Read JSON from a file.mp45.91MB
~Get Your Files Here !/10. Working with JSON files in VBA/4. Export excel to Json.mp46.99MB
~Get Your Files Here !/10. Working with JSON files in VBA/5. Export excel to Json file.mp42.83MB
~Get Your Files Here !/10. Working with JSON files in VBA/6. Export Excel to Nested JSON.mp44.5MB
~Get Your Files Here !/11. Miscellaneus/1. ODBC Query.mp413.02MB
~Get Your Files Here !/11. Miscellaneus/10. Send Email using Outlook application Object.mp48.25MB
~Get Your Files Here !/11. Miscellaneus/2. OLE DB Query.mp421.6MB
~Get Your Files Here !/11. Miscellaneus/3. Export to text.mp416.95MB
~Get Your Files Here !/11. Miscellaneus/4. Text Import.mp417.43MB
~Get Your Files Here !/11. Miscellaneus/5. Web Query.mp45.69MB
~Get Your Files Here !/11. Miscellaneus/6. OLEObjects.mp411.62MB
~Get Your Files Here !/11. Miscellaneus/7. Parse HTML code in Excel with VBA.mp427.45MB
~Get Your Files Here !/11. Miscellaneus/8. Get the elements of a website's HTML in VBA (alternative method).mp418.13MB
~Get Your Files Here !/11. Miscellaneus/9. Send Email using CDO.mp49.27MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/1. Prepare a table.mp414.16MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/10. Insert Rows and Columns into an Excel Table.mp46.4MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/11. Delete parts of an Excel Table.mp415.49MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/12. Delete an entire Excel Table.mp42.12MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/13. Delete data in an Excel table.mp410.7MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/14. Loop through the columns of an Excel table.mp48.62MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/15. Loop through the rows of an Excel table.mp416.07MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/16. Store Excel Table Data Into an Array.mp412.96MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/17. Store Excel Table Data Into an Array reference to a specific column.mp410.38MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/18. Resize an Excel Table.mp416.76MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/19. Resize an Excel Table by rows andor columns.mp412.01MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/2. What Is a Table.mp412.69MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/20. Clear Out an Excel Table delete the elements.mp47.74MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/21. Clear out an Excel Table clear the values.mp42.15MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/22. Get the list of tables in an Excel workbook.mp48.8MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/23. Get The Active Table in an Excel workbook.mp413MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/24. Insert a sum into an Excel table.mp413.18MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/25. Change formulas in total row in an Excel table.mp46.58MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/26. Create Tables in Excel with VBA.mp416.55MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/27. Set an Excel table back to a range.mp48.17MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/28. Sort Excel Tables with VBA.mp412.4MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/29. Filter Excel Tables with VBA.mp45.69MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/3. Format and manage a table.mp410.12MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/30. Clear Toggle Excel Table Filters with VBA.mp43.4MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/4. Retrieve an Excel table information with VBA.mp48.78MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/5. Select the header of an excel table with VBA.mp43.3MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/6. Select the body data of an Excel table with VBA.mp43.9MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/7. working with the columns of an Excel table with VBA.mp48.77MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/8. Select ranges in an Excel table with VBA.mp48.84MB
~Get Your Files Here !/2. Manage Excel Tables with VBA/9. Automate style options of Excel tables with VBA.mp414.12MB
~Get Your Files Here !/3. VBA Dictionary/1. What is the VBA Dictionary.mp410.21MB
~Get Your Files Here !/3. VBA Dictionary/10. Remove items from a VBA Dictionary.mp412.05MB
~Get Your Files Here !/3. VBA Dictionary/11. The count property of a VBA Dictionary.mp44.71MB
~Get Your Files Here !/3. VBA Dictionary/12. The VBA Dictionary Keys and Case Sensitivity (I).mp49.63MB
~Get Your Files Here !/3. VBA Dictionary/13. The VBA Dictionary Keys and Case Sensitivity (II).mp49.1MB
~Get Your Files Here !/3. VBA Dictionary/14. Read the elements of a VBA Dictionary.mp414.51MB
~Get Your Files Here !/3. VBA Dictionary/15. Sort a VBA Dictionary by keys.mp421.73MB
~Get Your Files Here !/3. VBA Dictionary/16. Sort a VBA Dictionary by values.mp415.14MB
~Get Your Files Here !/3. VBA Dictionary/17. Case study dictionaries with arrays (Part I).mp49.03MB
~Get Your Files Here !/3. VBA Dictionary/18. Case study dictionaries with arrays (Part II).mp412.36MB
~Get Your Files Here !/3. VBA Dictionary/19. Case study dictionaries with arrays (Part III).mp413.99MB
~Get Your Files Here !/3. VBA Dictionary/2. Define a dictionary as native object.mp43.72MB
~Get Your Files Here !/3. VBA Dictionary/20. Case study dictionaries with arrays (Part IV).mp410.54MB
~Get Your Files Here !/3. VBA Dictionary/21. Case study dictionaries with arrays (Part V).mp44.47MB
~Get Your Files Here !/3. VBA Dictionary/22. When to use a VBA Dictionary.mp44.4MB
~Get Your Files Here !/3. VBA Dictionary/3. An example to understand what is VBA Dictionary start from the VLOOKUP function.mp45.03MB
~Get Your Files Here !/3. VBA Dictionary/4. Verify and populate a Dictionary.mp414.49MB
~Get Your Files Here !/3. VBA Dictionary/5. Create a Dictionary as a Scripting object and as a generic object.mp49.4MB
~Get Your Files Here !/3. VBA Dictionary/6. Early versus Late Binding.mp45.83MB
~Get Your Files Here !/3. VBA Dictionary/7. Add Items to a VBA Dictionary.mp48.25MB
~Get Your Files Here !/3. VBA Dictionary/8. Assign a Value to a key in a VBA Dictionary.mp44.99MB
~Get Your Files Here !/3. VBA Dictionary/9. Check if a Key Exists.mp45.67MB
~Get Your Files Here !/4. VBA Collections/1. What is a Collection.mp410.78MB
~Get Your Files Here !/4. VBA Collections/10. Add Items to a collection using a key.mp410.12MB
~Get Your Files Here !/4. VBA Collections/11. Verify if a Key exists in a Collection.mp47.18MB
~Get Your Files Here !/4. VBA Collections/12. Loops to Accessing all items in a Collection.mp411.29MB
~Get Your Files Here !/4. VBA Collections/13. Convert a collection to an Array.mp410.54MB
~Get Your Files Here !/4. VBA Collections/2. Explain a collaction.mp45.72MB
~Get Your Files Here !/4. VBA Collections/3. Collections Vs Arrays.mp419.09MB
~Get Your Files Here !/4. VBA Collections/4. Advantages and disadvantages of Collections.mp43.32MB
~Get Your Files Here !/4. VBA Collections/5. How to Create a Collection.mp43.93MB
~Get Your Files Here !/4. VBA Collections/6. Remove All items from a Collection.mp49.76MB
~Get Your Files Here !/4. VBA Collections/7. Remove All – An Alternative Method.mp44.74MB
~Get Your Files Here !/4. VBA Collections/8. Add items to a Collection.mp410.2MB
~Get Your Files Here !/4. VBA Collections/9. Get Items of a Collection.mp43.88MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/1. Create A Pivot Table.mp425.77MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/10. Remove Calculated Pivot Fields.mp45.28MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/11. Report Filter On A Single Item.mp47.28MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/12. Report Filter On Multiple Items.mp46.13MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/13. Clear Report Filter.mp43.9MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/14. Refresh Pivot Table(s).mp46.43MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/15. Refresh all Pivot Tables in a workbook.mp42.62MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/16. Change Pivot Table Data Source Range.mp426.18MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/17. Grand Totals.mp43.69MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/18. Report Layout.mp43.07MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/19. Formatting A Pivot Table's Data.mp48.45MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/2. Delete a specific Pivot Table.mp45.62MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/20. Formatting A Pivot Field's Data.mp44.68MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/21. Referencing Pivot Table Ranges in VBA.mp413.55MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/3. Delete All Pivot Tables.mp49.98MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/4. Retrieve the luist of pivot fields.mp47.46MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/5. Add Pivot Fields.mp411.37MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/6. Add Calculated Pivot Fields.mp44.11MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/7. Add Values Fields.mp43.27MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/8. Remove Pivot Fields.mp42.54MB
~Get Your Files Here !/5. Manage Excel Pivot tables with VBA/9. Remove All Pivot Fields.mp45.17MB
~Get Your Files Here !/6. Excel QueryTables and VBA/1. QueryTables in VBA.mp418.02MB
~Get Your Files Here !/6. Excel QueryTables and VBA/10. Retrieve data from a uebsite and import into an Excel QueryTable with VBA.mp414.88MB
~Get Your Files Here !/6. Excel QueryTables and VBA/2. QueryTables and Querytables collections.mp49.82MB
~Get Your Files Here !/6. Excel QueryTables and VBA/3. The parameters needed to define a QueryTable.mp43.04MB
~Get Your Files Here !/6. Excel QueryTables and VBA/4. Import Access data into an Excel QueryTable using VBA (II).mp412.88MB
~Get Your Files Here !/6. Excel QueryTables and VBA/5. Import from text file into an Excel QueryTable using VBA (fixed width).mp422.48MB
~Get Your Files Here !/6. Excel QueryTables and VBA/6. Import from text file into an Excel QueryTable using VBA (delimited).mp414.25MB
~Get Your Files Here !/6. Excel QueryTables and VBA/7. import several text files.mp47.9MB
~Get Your Files Here !/6. Excel QueryTables and VBA/8. import csv file into an Excel QueryTable in VBA.mp410.42MB
~Get Your Files Here !/6. Excel QueryTables and VBA/9. Append data from different text file to a QueryTable.mp416.81MB
~Get Your Files Here !/7. Excel Exchange data with MS Access using VBA/1. Import Access data into an Excel QueryTable using VBA (I).mp416.14MB
~Get Your Files Here !/7. Excel Exchange data with MS Access using VBA/2. Export Excel data to Access in VBA.mp416.49MB
~Get Your Files Here !/7. Excel Exchange data with MS Access using VBA/3. Insert an Excel range of data into Access with ADODB VBA and SQL commands.mp422.89MB
~Get Your Files Here !/7. Excel Exchange data with MS Access using VBA/4. Insert an Excel range of data into Access with ADODB VBA with recordset.mp417.5MB
~Get Your Files Here !/7. Excel Exchange data with MS Access using VBA/5. Import an Excel table (listobject) into Access with VBA.mp424.45MB
~Get Your Files Here !/7. Excel Exchange data with MS Access using VBA/6. Import Excel table into Access with VBA looping in the table data using SQL.mp412.02MB
~Get Your Files Here !/7. Excel Exchange data with MS Access using VBA/7. Import Excel table into Access looping in the table data with ADO recordset.mp48.26MB
~Get Your Files Here !/7. Excel Exchange data with MS Access using VBA/8. Update Access with Excel data with VBA.mp418.81MB
~Get Your Files Here !/8. Working with XML files in VBA/1. Import XML into QueryTable.mp410.17MB
~Get Your Files Here !/8. Working with XML files in VBA/10. XML DOM nodes in VBA populate a range with XML nodes and their attributes.mp47.06MB
~Get Your Files Here !/8. Working with XML files in VBA/11. XPath in VBA.mp413.13MB
~Get Your Files Here !/8. Working with XML files in VBA/12. XML Attributes and tags in VBA.mp423.46MB
~Get Your Files Here !/8. Working with XML files in VBA/13. Parse XML in VBA and get single nodes.mp426.03MB
~Get Your Files Here !/8. Working with XML files in VBA/14. Simple routine to read into an XML file in VBA.mp420.24MB
~Get Your Files Here !/8. Working with XML files in VBA/15. Get data from the web.mp411.43MB
~Get Your Files Here !/8. Working with XML files in VBA/16. Searching through highest node level in XML Document.mp416.03MB
~Get Your Files Here !/8. Working with XML files in VBA/17. Export Excel data to XML file with VBA and XMLDOM.mp426.79MB
~Get Your Files Here !/8. Working with XML files in VBA/18. Export Excel data to XML file with VBA.mp425.31MB
~Get Your Files Here !/8. Working with XML files in VBA/19. Create an XML-file from a named Excel range.mp414.84MB
~Get Your Files Here !/8. Working with XML files in VBA/2. Loading XML file in VBA.mp410.76MB
~Get Your Files Here !/8. Working with XML files in VBA/20. Import an XML file into an Excel range with ADODB.mp412.39MB
~Get Your Files Here !/8. Working with XML files in VBA/21. Excel XMLMAp import to worksheet in VBA.mp419.89MB
~Get Your Files Here !/8. Working with XML files in VBA/22. Generate an XSD file with VBA.mp48.17MB
~Get Your Files Here !/8. Working with XML files in VBA/23. Import XML data in an ordered list in Excel.mp412.29MB
~Get Your Files Here !/8. Working with XML files in VBA/24. MSXML node types.mp416.05MB
~Get Your Files Here !/8. Working with XML files in VBA/25. Load an XSD file in a XML MAP using OpenXML.mp49.58MB
~Get Your Files Here !/8. Working with XML files in VBA/26. Open XML directly and load it into an Excel Workbook.mp46.53MB
~Get Your Files Here !/8. Working with XML files in VBA/27. Manage XML errors.mp417.16MB
~Get Your Files Here !/8. Working with XML files in VBA/28. XML async attribute.mp44.36MB
~Get Your Files Here !/8. Working with XML files in VBA/3. Loading XML structure in VBA.mp48.29MB
~Get Your Files Here !/8. Working with XML files in VBA/4. XML DOM nodes in VBA DOMDocument, nodes and childnodes.mp45.42MB
~Get Your Files Here !/8. Working with XML files in VBA/5. XML DOM nodes in VBA Childnodes items and length.mp48.76MB
~Get Your Files Here !/8. Working with XML files in VBA/6. XML DOM nodes in VBA nodelists.mp43.06MB
~Get Your Files Here !/8. Working with XML files in VBA/7. XML DOM nodes in VBA firstchild and children.mp41.65MB
~Get Your Files Here !/8. Working with XML files in VBA/8. XML DOM nodes in VBA node text.mp43.35MB
~Get Your Files Here !/8. Working with XML files in VBA/9. XML DOM nodes in VBA node attributes.mp41.95MB
~Get Your Files Here !/9. Excel VBA and Web services/1. Invoke a SOAP webservice from Excel.mp422.1MB
~Get Your Files Here !/9. Excel VBA and Web services/10. responseXML Property (IXMLHTTPRequest).mp412.9MB
~Get Your Files Here !/9. Excel VBA and Web services/2. SOAP Request via VBA in Excel.mp44.51MB
~Get Your Files Here !/9. Excel VBA and Web services/3. SOAP - Using VBA to send XML to WSDL.mp413.59MB
~Get Your Files Here !/9. Excel VBA and Web services/4. Create a SOAP RequestResponse using XML from VBA.mp48.45MB
~Get Your Files Here !/9. Excel VBA and Web services/5. Send HTTP requests with VBA from Excel with WinHttp.mp47.93MB
~Get Your Files Here !/9. Excel VBA and Web services/6. How to make REST call with VBA in Excel WinHttp.mp47.58MB
~Get Your Files Here !/9. Excel VBA and Web services/7. How Do I Get Http Request In Excel Vba.mp44.96MB
~Get Your Files Here !/9. Excel VBA and Web services/8. Add a POST example.mp422.24MB
~Get Your Files Here !/9. Excel VBA and Web services/9. Http requests in Excel VBA.mp412.68MB