John Nurick’s Code PageThis site contains various “library” functions or scripts I have found useful over the years. Most of them have previously appeared in newsgroup postings. You are welcome to use this code in your applications or to help deal with your data, but in doing so you take responsibility for its behaviour. In short: use it at your own risk. VB/VBA functionsThese functions were written for VBA but can mostly be used with little or no modification in classic Visual Basic.
VBA functions using regular expressionsThese versatile VBA functions use the VBScript regular expression object to do powerful pattern matching in VBA and classic Visual Basic.
VBScripts
Perl and Perl scriptsPerl is a programming and scripting language with immensely powerful built-in text-handling functions. Some people call it the Swiss Army chainsaw of the programming world. Others complain, not unfairly, that Perl code looks like line noise interpreted by a modem. I use it for mostly munging text files (which it does far more elegantly than any dialect of Visual Basic), but it can do OLE Automation and therefore automate Access/Jet and the other Office applications. VBA functions inspired by PerlThese are translations into Classic VB/VBA of a handful of useful functions found in Perl and some other high level scripting languages. Importing data from Microsoft Works databasesAccess doesn't come with any way of importing data from a Microsoft Works database (.wdb file). The best approach is to use Works to export the data into a format that Access can handle (e.g. CSV). If you don't have access to Works, Excel can open some old Works files. Or you can try this sample database, which contains VBA code that takes advantage of Word's ability to use a Works database as a mailmerge data source. You're welcome to use the code it contains, but any debugging it needs you'll have to do for yourself. It requires Office 2000 or later and probably won't work with all versions of Works or all Works databases - but it's better than nothing. |
Software >