能否不打开excel表格而操作excel表格 Post By:2016/11/27 13:58:00 [只看该作者]
Dim App As New MSExcel.Application Dim temp As String temp = "e:\项目设计\操作表\表格数据提取表.xlsm" Dim Wb As MSExcel.Workbook wb = getobject(temp) Wb.WorkSheets(2).Range("D1") = e.Form.Controls("TextBox1").value Wb.SaveAs("e:\项目设计\操作表\表格数据提取表.xlsm") App.Quit