I wouldn't say I have "working knowledge" of VBA, but I've coded a couple of personal projects in it. Currently I'm working on a parsing/printing Java program that involves 4e statblocks.
The main function you're looking for is StrComp(string1, string2). You have to match the strings exactly...