Have you tried installing the VBA compatibility toolkit to see if the tool runs? VBA is no longer supported, but you should be able to continue to consume VBA extensions. If the tool were to fail or throw an exception you'd want to convert it to a supported language (i.e. Java, C++ or .NET). Looking at the sample you posted all of the code is hosted within the Map Document. Have you tried converting this to a COM Component or Addin in a supported language?
