我用以下的代码导出EXCEL成功,同时在我的文档中会出现一个Book1的新文件,打开导出的EXCEL文件时我的文档中的文件也同时被打开,每导出一次在我的文档中就多出一个Book2、Book3……如何去除这个问题?谢谢!Set oexcel = CreateObject("Excel.Application")
Set obook = oexcel.Workbooks.Add
Set osheet = obook.Worksheets(1) Adodc1.RecordSource = "SELECT * FROM CLK ORDER BY CL_ID"
Adodc1.Refresh
oexcel.Visible = False osheet.Range("A3").CopyFromRecordset Adodc1.Recordset
osheet.Name = "库" '工作薄名等于当前工程名
obook.SaveAs CommonDialog1.FileName '& "\" & CurProName & "表.xls"
oexcel.Quit
Set osheet = Nothing
Set obook = Nothing
Set oexcel = Nothing
Set obook = oexcel.Workbooks.Add
Set osheet = obook.Worksheets(1) Adodc1.RecordSource = "SELECT * FROM CLK ORDER BY CL_ID"
Adodc1.Refresh
oexcel.Visible = False osheet.Range("A3").CopyFromRecordset Adodc1.Recordset
osheet.Name = "库" '工作薄名等于当前工程名
obook.SaveAs CommonDialog1.FileName '& "\" & CurProName & "表.xls"
oexcel.Quit
Set osheet = Nothing
Set obook = Nothing
Set oexcel = Nothing
Set obook = oexcel.Workbooks.Add
Set osheet = obook.Worksheets(1) Adodc1.RecordSource = "SELECT * FROM CLK ORDER BY CL_ID"
Adodc1.Refresh
oexcel.Visible = False
osheet.Range("A3").CopyFromRecordset Adodc1.Recordset
osheet.Name = "库" '工作薄名等于当前工程名
obook.SaveAs CommonDialog1.FileName '& "\" & CurProName & "表.xls"
oexcel.Quit
Set osheet = Nothing
Set obook = Nothing
Set oexcel = Nothing
Set obook = oexcel.Workbooks.Add
Set osheet = obook.Worksheets(1) Adodc1.RecordSource = "SELECT * FROM CLK ORDER BY CL_ID"
Adodc1.Refresh
oexcel.Visible = False
osheet.Range("A3").CopyFromRecordset Adodc1.Recordset
osheet.Name = "库" '工作薄名等于当前工程名
obook.SaveAs CommonDialog1.FileName '& "\" & CurProName & "表.xls"
oexcel.Quit
Set osheet = Nothing
Set obook = Nothing
Set oexcel = Nothing
obook.close
obook.close(True)