There is a lot to like in this article, but the artificial division between Excel and VBA for Excel is well, artificial. I've since moved to other coding environments like R and python, but in the past I frequently used VBA to parse and tabulate excel files; Excel VBA is quite capable of a lot of complex manipulations...often done slow as hell...but capable.