Create Text File with FSO and VBA CreateTextFile
Aug 31, 2018
Use the FileSystemObject TextStream to create a text file with VBA CreateTextFile. The combination of TextStream and CreateTextFile make creating text files a breeze.
VBA Switch and VBA Select Case
Aug 30, 2018
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!
Ultimate VBA Training Bundle
$80.00 $52.00
We've combined each of our comprehensive wellsrPRO VBA training reference guides into a single bundle with over 150 tips and macros covering the 80 most important topics in VBA.
+ACI-Excel VBA Dictionary Keys and Items+ACI-
Aug 24, 2018
Use a VBA dictionary to create a collection of key-item pairs in Excel. The VBA dictionary object links keys to items so you can get your items later by simply calling the key.
Excel VBA AutoFilter to Filter Data Table
Aug 22, 2018
Use VBA AutoFilter to filter data in Excel. The VBA AutoFilter method lets you filter multiple fields at once and even filter on more than one criteria.
VBA Regex Regular Expressions Guide
Aug 19, 2018
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.
Mouse to Macro Excel Add-in
$15.00
Use Excel to record your mouse clicks and cursor movements and convert them directly into VBA macros so you can easily automate complex tasks, like copying data from a website.
VBA PasteSpecial Values, Formats, Formulas and more
Aug 17, 2018
Use the VBA PasteSpecial Method to paste values, formats, formulas and more. You can even use VBA PasteSpecial to perform math on entire ranges and transpose data.
VBA Select Files with msoFileDialogFilePicker
Aug 10, 2018
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.
Using Excel VBA to Send Emails with Attachments
Aug 8, 2018
This tutorial will demonstrate how to use Excel VBA to send emails with attachments, and we will take a detailed look at the Attachments object, which is actually a collection. It's quite easy to attach files to an email using Excel VBA.
VBA DoEvents and when to use it
Aug 3, 2018
VBA DoEvents yields execution of your macro, so your computer processor will be able to simultaneously run other tasks. The VBA DoEvents function also enables interruption of code execution so it's easier to stop a running macro.
VBA Send Email from Excel
Aug 1, 2018
Use VBA to send emails from Excel with Outlook. This tutorial provides a macro for sending emails from Excel, tells you how to use Excel VBA to send emails with attachments and add a body to your emails.
subscribe via RSS
