Batch file to run excel macro

[shotta]

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

[hulpeloos]

In BAT

start Excel.exe "C\yourfilename.xlsm"

In Excel (under ThisWorkbook)

Private Sub Workbook_Open()
'your code to do what it needs to referesh
...
Application.DisplayAlerts = False
activeworkbook.Close
Application.DisplayAlerts = True
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayAlerts = False
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub

[shotta]

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

[shotta]

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