Hi... I'm currently have 10+ years of experience with VB and VBA by now. My specialty is cross multiple programming language projects which includes Delphi/Pascal, VB/VBA, and C/C++...
I have many experience with VBA based macro projects. If you don't mind to do the project in Delphi language, since I no longer have VB6, and Delphi is my primary programming language for now.
I'm sure I can do the best for your need.