Excel VBA Macros: Forms, Files, and Data Handling
By External Provider
About this course
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 have a recent version of Microsoft Excel installed. The course setup instructions provided in the first course go into more detail about the hardware and software requirements.
What you will learn
- You will use VBA to develop custom forms, read/ write data, clean and transform data, run programs outside of Excel, and share VBA projects.