VC编程实现运行Excel宏 Run

以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);