Code Library - No Longer Set (Page 7)

One Thing at a (Hundred) Times

How to use Run() and GetTickCount() for some quick and dirty performance profiling. Come for the code, stay for the scolding on premature optimization.

Hidden Features

A Rounding We Will Go

Two kinds of rounding, the VBA language spec vs. the Office VBA implementation, and a drop-in replacement for VBA.Round().

Code Library

Come Together

Do you build strings in loops? Stop trimming the delimiter at the end of the loop. There's a better way.

Code Library

Quoth thy SQL? Evermore!

Solving the "O'Malley problem" with dedicated functions to sanitize our strings. Little Bobby Tables would be proud.

Testing

Python-inspired Doc Tests in VBA

Doc tests are not a replacement for unit or integration testing. But they do provide the best return on investment (ROI) of any type of test, mostly because the effort to write them is near zero.