Batch file to run excel macro

how do i excecute a refresh macro in excel by using a batch file, instead of opening the excel file i would just click the .bat from my desktop and it should open the excel spreadsheet and run the refresh macro automatically then close the excel sheet

Thanks however my refresh macro accesses a form which runs sql codes and updates the pivot tables on the worksheets. So if I put this code in the THisworkbook section it will not work because not everyone had db access. This batch is just for a few employees I don't want the batch to execute each time the workbook opens, I only want it execute when the refreshALL macro is called. Can yu assist

Anyone knows how to access a macro from a batch file and make it to where , only the person running the batch can access the macro, otherwise the speadsheet can viewed without triggering the macro to run when they open the spreadsheet. I am using excel. 2010