怎么用vb操作EXCEL, 实现数据组合?

来源:百度知道 编辑:UC知道 时间:2024/05/27 00:31:51

dim xls as excel.application
set xls=createobject(excel.application)
set ebook =xls.workbook
set esheet=xls.worksheet
ebook.open " excel path"
esheet.activate
esheet.cells(i,j)=""
ebook.saveas "path"
xls.quit
随手写的,调试下应该能用