是否可以从外部命令在Excel中运行宏？

Let's say I want to program a VBA code in an external program that opens an Excel file, runs a macro, saves (and say yes to any pop up windows), and close Excel. Is it possible to do so? If so, how would I go about implementing it?Let's say I want to program a VBA code in an ex