Download Update: VBA and Excel…Part 2
Uncategorized
Special Features
Besides the news and articles that we publish here on GeoPrac, there are a few other items that don’t fit in any of the other menus. We refer to these gems as “Special Features”. Downloads […]
Rockman's Ramblings
A Geoengineer’s Christmas List 2010
So last year at this time, I gave Santa my geoengineer’s Christmas list, but apparently I wasn’t good enough to get everything. I did get two things off my list, the new FHWA Drilled Shaft Manual, and the New FHWA MSE Wall Manual, but that’s about it. That’s like getting pink bunny PJ’s as a kid! So over the last year, I tried to be REALLY good, and this year I’ll just let last year’s list roll over with two additions:
An iPad
This year’s hottest gift would be great for reading my growing library of geotechnical papers, manuals, reports and books in PDF format. I like the iBook app on my iPhone, especially being able to highlight and make notes and bookmarks. And you can read an eBook allright, but try reading a scanned PDF report or paper on that little screen, doesn’t work too well. I like the idea of having my entire library of technical papers, books and reports available at my fingertips!
And the coolest goodie on my list, the one I really want… […]
Articles
VBA and Excel for Engineers and Scientists – Part 2
In this long awaited second article in the series, I will dive into the meat of the VBA programming language, including code containers, data types, variables, math operators, built-in functions, flow control, and even debugging.. In the end, you should be able to code some fairly complex things including custom worksheet functions that you can use in your spreadsheet just like a regular formula. Also in this article I give you a sample spreadsheet with some useful utilities that you can use right away.