It seems like the bigger concern would be all the important data they have in Lotus Notes, as well as some of the other systems mentioned.

VBA seems like a solid choice compared to where they have their data being stored.