Excel VBA Macros: Forms, Files, and Data Handling

To round out your data-analysis skills in VBA for Excel, you'll display a custom dialog box and program form events. You'll also use VBA to get file and directory structure, read from text files, and write to text files. Then, you'll clean and transform data by automating Power Query, transform data using VBA and workbook functions, using regular expressions, and managing errors in data. Lastly, you'll run other programs and commands and share your VBA projects. This is the third and final course in a multi-course Specialization. All of the courses in this Specialization require that you hav…