引用excel对象 dim xpp as excel.application dim xworkbook as excel.workbook dim xworksheet as excel.worksheet dim excelsheetname() as string '对各个对象进行引用 '略 redim excelsheetname(xworkbook.worksheets.count)for i=1 to xworkbook.worksheets.count excelsheetname(i-1)=xworkbook.worksheets(i).name next i'field同上
dim xpp as excel.application
dim xworkbook as excel.workbook
dim xworksheet as excel.worksheet
dim excelsheetname() as string
'对各个对象进行引用
'略
redim excelsheetname(xworkbook.worksheets.count)for i=1 to xworkbook.worksheets.count
excelsheetname(i-1)=xworkbook.worksheets(i).name
next i'field同上