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
Microsoft Access
Connect to MS Access Database with Javascript | HTA App
This one is a work in progress. The end goal is to build an easy scaffold for users to quickly build an HTA CRUD interface that connects to an MS Access database. For those of you who don't know what an HTA application is, you can read a very high level explanation here: https://en.wikipedia.org/wiki/HTML_Application HTA is wildly out of fashion. Most people don't know what … [Read more...] about Connect to MS Access Database with Javascript | HTA App
Search Text With Regular Expressions in VBA | RegEx VBA
For text items that are difficult to parse, regular expressions can come in handy. For this example, I put together a function that parses email addresses from string text. For simplicity and reference-sake, I adopted an email regex search pattern from: https://www.regular-expressions.info/email.html. Not all use cases are created equally, re-purpose my example as needed. … [Read more...] about Search Text With Regular Expressions in VBA | RegEx VBA
Import Multiple Spreadsheets into Access | File Dialog VBA
Sometimes it would be great to combine a bunch of spreadsheets into one table. When working with consolidated spreadsheet data, be sure to manage duplicates. To import multiple spreadsheets into Access with VBA, there are a few housekeeping items that must be completed. First, you need to make sure that the data structure for all of your source files is the same. Field names, … [Read more...] about Import Multiple Spreadsheets into Access | File Dialog VBA
Download Outlook Calendar VBA Example
Wow time is flying! Looks like my last post was in June! I built this example due to frustration. I was trying to find a way to look at and manipulate appointments in my Outlook calendar for a three month time span. The tool that I built, ultimately loaded the pulled outlook calendar items into a table. I decided not to include that part in this article as it is pretty … [Read more...] about Download Outlook Calendar VBA Example