start Excel file with macro from batch file with no question asked - how ?

[mrchonginhk]

I have an Excel file with macro.
I need to use batch file to start it but since it has macro, the process was stuck and need somebody to manually click yes.

I remember there is a parameter or switch in batch file to start the Excel without asking macro Yes No.

Anyone can help to solve this problem ? Thanks

 

[ZAX]

Enter This Line Of Code :

'code here
Application.DisplayAlerts = False
'code here

ZAX

 

[par60056]

I hope there is not such a parameter. That would make it easy for virus writers.

What you can do is go into excel options and add the place that the file is in to the trusted zones.

Go to Options then select the "Trust Center" and click "Trust Center Settings" and select "Trusted Locations"