dim appexcel
'创建Excel对象
set AppExcel=createobject("excel.application")
'新增一个工作簿
AppExcel.workBooks.add
'取得工作簿
Set OLNewBook=AppExcel.ActiveWorkbook
set DataSheet = OLNewbook.Sheets("sheet1")
DataSheet.Activate
....
....
我想让生产的文档有2个sheets,但是系统默认是3个,怎么解决,谢谢了
'创建Excel对象
set AppExcel=createobject("excel.application")
'新增一个工作簿
AppExcel.workBooks.add
'取得工作簿
Set OLNewBook=AppExcel.ActiveWorkbook
set DataSheet = OLNewbook.Sheets("sheet1")
DataSheet.Activate
....
....
我想让生产的文档有2个sheets,但是系统默认是3个,怎么解决,谢谢了
datasheet.delete
set DataSheet = OLNewbook.Sheets(3)
datasheet.delete
set DataSheet = OLNewbook.Sheets(3)
datasheet.delete
set DataSheet = OLNewbook.Sheets(2)
datasheet.delete
加一句 datasheet.Delete
datasheet.delete
OLNewbook.save
set datasheet =nothing
OLNewbook.close
set OLNewbook = nothing
AppExcel.quit
set AppExcel=nothing