Recently, I was working on a side project that did some cool things with business days. In one of the use cases, I needed to figure out the date five business days from the current date. My solution needed to be built for technical staff to easily modify exclusion dates. My solution also had to be something that could be set once and forgotten as the end-user pool is expected … [Read more...] about Calculate Business Days in VBA Without Table
Microsoft Excel
Send Email Through Outlook with VBA
I have to say that I have been super hesitant to share this example as it could be used by spammers. That being said, there are plenty of legit uses for sending email through Outlook with VBA. I have used this function primarily to automate the delivery of scheduled reports where I pull in an HTML template (fancy), replace template "placeholders" and have the report sent to a … [Read more...] about Send Email Through Outlook with VBA
MS Word Document text to String with VBA
I once had a project where I had to work with a large directory of unsorted word documents. The main directory had a deep sub-directory where there were multiple versions of the same document with the same file name. It was a mess. Basically, my responsibilities were to pull out unique document filenames with the most recently modified version and parse each document for a … [Read more...] about MS Word Document text to String with VBA