Here you will find VBA routines, Tips and tricks and Links I find useful for serious Excel work.

VBA routines and more... (All work in Excel 2000) (Back to top)

Log.xls Standard routines for creating log files. I use these routines to display information useful for me when debugging, and also to give a user information on what's going on.
Cutter.xls Program to get text file information into Excel in a convenient way. Text imports once in a while can be easily done with Excel's open routine, together with some manual editing, but when these imports are done on a more frequent schedule you need to do something different. Cutter offers an easy way to do just that.
DirWorks.xls Various routines you may need when working with files and directories
Subs.xls Various other routines

 

Tips and tricks (Back to top)

Links (Back to top)