以Excel2007为例
请自行根据不同版本的Excel库进行相应的更改
CApplication xlsAppLication;
//初始化略
CString macro = _T("macro");//excel文件中的宏名字
例如：假如宏的名字是marco1 那么就传入macro = _T("macro1");
xlsAppLication.Run(_variant_t(macro),vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,
vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,
vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing);