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
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 in VBA with file dialog post. The original FileDialog post referenced above shows an example … [Read more...] about SOLVED: Late Binding File Dialog in VBA Example
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, SEO content, etc... resulting in a current audience of … [Read more...] about We are now the Minnesota IT Hub
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