Join Curt Frye for an in-depth discussion in this video What you should know before watching this course, part of Excel VBA: Process Modeling (2016).
- [Voiceover] Before we get started with Process Modeling in Excel using the VBA, I'd like to give you a brief overview of some things that you should know to get the most out of this course. The first is that we will be working pretty much exclusively with macros and Visual Basic for Applications code. So, understanding how to set your macro security in Office will be useful. Also, you should have basic proficiency in Excel VBA. While the processes that you'll build as part of this course are a little bit complicated, at least on a conceptual level, I think you'll be able to get by fairly easily if you have basic proficiency in Excel VBA.
So, things such as variable declarations, working with object variables, and for-next, for-each, and if-then loops will all be handy. Unlike many of the other courses that I have created for Lynda.com, you'll find that movies build progressively within a chapter. So what we'll do is we'll start by building the first part of the solution, and then move on throughout the chapter until at the very end, we have the code that we're looking for.
That means that not every movie ends up with code you can run. So, you might make some changes, and create a skeleton or perhaps an outline for a number of routines, and the code that you end up with at the end of a particular movie might not run properly. However, the workbooks will all contain the previous code from the chapter. So, when we are building our solutions, especially in chapters two through four, you will find that each subsequent notebook or workbook, contains the code that you need.
And finally, chapters two through four also include a workbook with the completed code for that chapter. So, you don't have to worry about maybe making one mistake and having it cascade throughout all of the movies in the chapter. The code will be there for you to work with and to examine. In chapter five, I take a slightly different approach. I offer you three different extensions to the models that we've built, especially in chapter four. And in that case, chapter five movie two will contain the build of a solution.
In other words, we'll add the code that we need, and then movie 0503 will have that code, and you will be able to run the simulation and see the results. So once again, if you are familiar with Excel VBA, and you understand how the course is structured, I think you'll get a lot out of what you see here.
- Creating a class module in VBA
- Defining class properties
- Creating collections
- Describing process flow and programming goals
- Creating loops
- Increasing capacity of a model
- Running simulations
- Analyzing simulation results