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 […]
SOLVED: Late Binding File Dialog in VBA Example
I have been trying to figure out a solution to late binding the file dialog object for a long time. I have played with the code, googled for examples and haven’t had much luck until today when a generous visitor of ours posted the solution in the comments of our Select or Open a file […]
We are now the Minnesota IT Hub
A long time ago (back in 2003) I started Ntech Communications (www.ntechcomm.com), an IT Consulting company for small business customers. This was my college job while I figured out what I wanted to be when I grew up. Over time, I transitioned the company domain name into a blog with various computing tips, code examples, […]
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. Also, […]
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 […]