One of the most powerful uses of scripting languages is in “application automation”, that is, the idea of automating a long sequence of steps such as: “select paragraph at cursor, indent 3″ right, ...

Visual Basic for Applications (or VBA as I'll call it from now on) is the programming environment where you will write and test macros and procedures that respond to various events that occur when you ...

VBA sub procedures can perform lots of tasks and there are many ways to execute those functions in Microsoft Excel. Once you stick your toe into the VBA waters, you’ll realize how powerful and ...