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: http://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
Archives for April 2015
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