Create your own functions in Excel with VBA user defined functions. VBA user defined functions allow you to perform complex calculations using lines of code rather than confusing nested Excel formulas.
You can use the FileSystemObject TextStream to open a text file in VBA by pairing it with the VBA OpenTextFile method. The VBA OpenTextFile method is a simple way to read, write, and append to text files.
This tutorial explains the difference between the VBA Switch function and the VBA Select Case statement. The VBA Select Case statement is sometimes called Switch Case, which can make distinguishing it from the Switch function rather confusing!
VBA RegEx, or Regular Expressions, are special character sequences that define search patterns and are used to identify specific patterns of characters in a string. This tutorial will explain VBA RegEx pattern examples so you can create your own regular expressions.
Use the VBA msoFileDialogFilePicker to browse for and select files with a macro. The msoFileDialogFilePicker property is part of the Application.FileDialog family in Excel and behaves much like the GetOpenFileName method.