Run VB macro non-interactively

I need to run a VB macro from a scheduled task. Before I added the automatic Pivot table to the module it used to run without problems in the middle of the night.
The VB code works successfully when I execute the macro manually. When launching it from the bat file the worksheet with VB only opens but does not kick off the macro.

When I comment out the code I added, I still get an open worksheet and the macro will not run unless I run it manually.

Any ideas would be welcome. Thanks.