Hello. I'm good in trading stuff. And as a professional I have to say it's really not a simple task. There are much pain with VB scripts.
But I can help you. Send me a message, and we'll do it. It requires time and money, but it's possible to do.
Actually, there is another way how to do it better. I can write you the python script, it will work with data, and than save it to xls files.