VBA Tutorial CodeSave Selected Emails with Custom Name VBA Outlook – Avoid Too Long Email Names
Sunday, November 14, 2021
The below code lets you select the name for an email before saving it. Make sure that you have the below enabled in Tools — References in your…
Create VBA shortcuts to Folder Paths
Sunday, November 14, 2021
In the above video, I show you how to add a RowSource in the View > Properties Window in the Visual Basic Editor. This rowsource value, similar to…
Quick Documentation
Wednesday, October 20, 2021
This article contains a quick way to document stuff. I don't feel like explaining it today. The first CommanButton1_Click executes the ok subprocedure in the Module 1. I…
Navigate Workbook by Clicking Cells
Saturday, April 10, 2021
The below code and workbook is a simpler way to navigate a workbook by clicking indicated cells so I don't have to move my mouse down to the…
Open many PDFs in Browser
Wednesday, March 24, 2021
The below code will show you how to open many Adobe PDF files in an Internet Explorer Browser window. You can combine this with my PDF text grabber…
Adobe PDF Text Grabber Excel
Saturday, March 20, 2021
In this article, I will walk through how to grab text from Adobe PDFs with Excel VBA. It's a simple process of using the mouse clicks, clipboard, and…
Salesforce Hospital Mobile App How to
Monday, January 4, 2021
30 second video showing the mobile app. I create a task and assign it to a floor, hospital, nurse, AND/OR patient (you can customize). I have reports built…
Thank You
Sunday, December 20, 2020
Thank you for submitting an order to Brian's Salesforce via his website.
Filter Criteria VBA one by one
Tuesday, July 23, 2019
The below code will copy column B to column P, remove duplicate dates, and then loop through each unique date in column P in column B. Get data…
Pivot Table Filter Excel VBA One by One
Tuesday, July 16, 2019
https://www.youtube.com/watch?v=SMdUEvBsO6s
Sub LoopThroughFilters() Dim annoying As Double Dim driversdict As Object, drivers As Variant, i As Long, Driver As Variant Set driversdict = CreateObject("Scripting.Dictionary") With ActiveSheet 'puts autofilter on…
Excel VBA Filter
