Understanding the VBA Editor

VBA has an easy-to-use interface called the Visual Basic Editor (VBE). In order to access the VBE, you first need to display the Developer tab. To show the Developer tab,  open a 2007 Office System application, for example Word 2007. Click the Microsoft Office Button, and then click Word Options. In the Top options for [...] . . . → Read More: Understanding the VBA Editor

Iterating over a Directory with a Dir Loop (Loop Through Directory) VB

VBA is potentially the greatest desktop ‘hammer’ you have at your disposal. You can pop open any Office application, hit ALT+F11 and be writing code before Visual Studio will even be open on most machines.
For doing ad hoc work around the office, VBA allows you to do things that applications alone simply aren’t powerful enough [...] . . . → Read More: Iterating over a Directory with a Dir Loop (Loop Through Directory) VB

Sponsors