C
Change_On_Insta
Unregistered / Unconfirmed
GUEST, unregistred user!
我用Excel的錄制宏的功能得到了如下代碼﹐但運行
說巨集不存在
FExcelApplication.Visible:=true;
FExcelApplication.Workbooks.Add(xlWBatWorkSheet);
excelworksheet1:=FExcelApplication.Workbooks[1].Worksheets['sheet1'];
FExcelApplication.Run('ATPVBAEN.XLA!Histogram',
excelworksheet1.Range['A1','A5'], excelworksheet1.Range['A6','I12'],
excelworksheet1.Range['B3','B5'], True, True
, True, False );
我試過給出絕對巨集的絕對路徑﹐但是也不行﹐該巨集確實存在
說巨集不存在
FExcelApplication.Visible:=true;
FExcelApplication.Workbooks.Add(xlWBatWorkSheet);
excelworksheet1:=FExcelApplication.Workbooks[1].Worksheets['sheet1'];
FExcelApplication.Run('ATPVBAEN.XLA!Histogram',
excelworksheet1.Range['A1','A5'], excelworksheet1.Range['A6','I12'],
excelworksheet1.Range['B3','B5'], True, True
, True, False );
我試過給出絕對巨集的絕對路徑﹐但是也不行﹐該巨集確實存在