R R_Baggio Unregistered / Unconfirmed GUEST, unregistred user! 2009-12-24 #1 ExcelApplication := CreateOleObject('Excel.Application');默认是打开宏的,如何能默认不要打开宏呢?
D de410 Unregistered / Unconfirmed GUEST, unregistred user! 2009-12-24 #2 Application.EnableEvents=false; Application.Workbooks.Open;Application.EnableEvents=true;
S stlont Unregistered / Unconfirmed GUEST, unregistred user! 2009-12-24 #3 你可以在excel中做对应操作,同时录制成宏,再对照宏代码改写,这个方法对绝大部分操作都适用