From the course: Excel VBA: Managing Files and Data

What you should know - Microsoft Excel Tutorial

From the course: Excel VBA: Managing Files and Data

Start my 1-month free trial

What you should know

“

- [Instructor] Thanks for your interest in working with Excel VBA files and data. Before I get started, I'd like to give you an overview of some topics that will be useful for you to get the most out of this course. The first is that you need to know how to change macro security settings. Most systems will limit or block macros, so you need to know how to change your settings to allow macros to run. I do not cover those techniques in this course. Next, you should be familiar with recording macros to generate useful code. When you work with more complicated workbook objects, such as pivot tables, you will find that it's almost impossible, or at least impractical, to write the code by hand. So instead, record your macros and learn how to edit the code there. Finally, with regard to Excel macros, you need to be able to comment your code effectively. It can get very tricky when you are working with code especially across multiple sub-routines or functions, so comments are a necessity. Next, I also hope that you will be familiar with Excel VBA structures, and those include referring it to properties and methods. We use many of both. Next, you should be facile with assigning values to variables, and that includes object variables, not just numbers and strings. And finally, you should have experience creating if and case statements. I only use if and case statements for some of the more advanced techniques in this course, but if you're familiar with them already, it will make learning them that much easier. Thanks again, and I look forward to working with you.

Contents