Written by Christopher Goodell, P.E., D.WRE | WEST Consultants
Copyright © The RAS Solution 2015. All rights reserved.
There has been a lot of demand from new owners of the book “Breaking the HEC-RAS Code” for example code in VBA form. So…here it is! Aside from the obvious fact that you wont have to re-type code from the book into your own Excel VBA modules, this Excel Workbook provides the benefit of seeing how each and every procedure in the HECRASController works.
That’s right, every subroutine, and every function are documented in this workbook, along with example code from a wide range of HEC-RAS automation procedures and some code snippets for error catching and string manipulation-very important when reading/writing HEC-RAS input files. In total, there are over 150 procedures and over 8000 lines of code for you to use for help while you create your own HEC-RAS automation projects.
Each procedure from the HECRASController is demonstrated in either a subroutine or function in this Excel Workbook. Each demonstration provides up-front commentary including the procedure's name, what it does, cautions and pitfalls to look out for, as well as what standard HEC data set it was tested with (i.e. Bald Eagle Creek, Beaver Creek, etc.).
There’s also commentary all throughout each demonstration so that you’ll know exactly what each block of code does.
The HECRASController VBA Code Excel Workbook will make a valuable companion to “Breaking the HEC-RAS Code”. Every bit of code presented in the book is available in digital form in the Excel Workbook. The HECRASController VBA Code is optimized for Version 5.0 of HEC-RAS. It will work right now with the current beta release, and will work with the official version when it is released.
The HECRASController VBA Code Excel Workbook is available here: