vba - MS Excel automation without macros in the generated reports. Any thoughts? -

I know that the web is full of questions like this, but I still can not apply the answers. My situation can be found.

I know that VBA is, but I did not always like to live the program / macro, resulting in bloat, security alerts, etc. I was living within the Excel file. Rows of a VBScript that work on sets of Excel files, while leaving them macro-free. Now, I am able to do "first column blue color" for all the files in a directory after this approach, but I need to do more complex operations (charts, pivot tables, etc.), which will be very difficult (impossible) ?) With VBS with VBS.

After processing, all the macros from the files will be enough to know how to remove it, but all suggestions are welcome, any good reference?

Thank you:

PS: I eagerly tried Mark Hammond's great PyWin32 package, but lack of documentation and interpreter feedback made me frustrated.

You can put your macros in a separate Excel file.