导读:1、定义excel操作变量 dim objexcelfile as excel.application dim objworkbook as excel.workbook dim objimportsheet as excel.worksheet 2、打开excel进程,并打开目标excel文件 set objexcelfile = new excel.application objexcelfile.displayalerts =
1、定义excel操作变量
dim objexcelfile as excel.application
dim objworkbook as excel.workbook
dim objimportsheet as excel.worksheet
2、打开excel进程,并打开目标excel文件
set objexcelfile = new excel.application
objexcelfile.displayalerts = false
set objworkbook = objexcelfile.workbooks.open(strfilename)