you can create a MS Excel object from Delphi application
 (as OLE server) and call/execute the any command/macro/procedure in it.    var xls: Variant;
begin
 xls := CreateOleObject('Excel.Application');     try
  ...
  xls.Run('yourMacroName');
 finally
  xls.Quit;
 end;
end;    If your macro have the parameters, you must call the
xls.Run('yourMacroName', Arg1, Arg2, ...);