i'm thinking you either need to digitally sign the workbook or make the folder it's in a trusted location. the problem i believe is the fact that you have to click enable macros, which you can't do with a batch file.
In Excel, try going to File > Options > Trust Center, then clicking on the "Trust Center Settings" button, then on the "Add New Location" button and take it from there.
Never tried signing a workbook, but that functionality is usually on the Start Menu > Microsoft Office > Microsoft Office 2010 Tools > Digital Certificate For VBA Projects
Good luck, gonna be away from comp, let me know if you figure it out