Hi,
I read your all requirements carefully and I come to understand that you want to make Excels file from a VBA script. I have practical experience of this work. If you reward this project to me, I will show you my abilities and done your project as per your requirements. And answer of your question is= 8.
Waiting for your kind response.
Regards,
Adeel Baig