Problem running excel macro from vbs file

I have a report that runs and creates some csv files. I have managed to create a macro and its saved into the personal.xlsb file. What I need to do is somehow run this from a batch file to open the csv, run the macro, and then save the csv and close excel without saving the xlsb.

I tried to run it from a vbs file which can be run from a command line, but it wont run my macro as it says its not available or macros are disabled. I made sure in trust center to enable all macros.


this is the code that is saved in a vbs file.

Please Login or Register  to view this content.

thanks in advance!
Chris

Thanks for Δtitle and code tags