Excelbook.SaveAs 保存不了文件
Set ExcelApp =CreateObject("Excel.Application")
ExcelApp.Application.Visible = False
' ExcelApp.WorkBooks.Open("e:/data.xls")
Set ExcelBook = ExcelApp.Workbooks.Add
ExcelBook.WorkSheets(1).cells(1,1).value="SN"
ExcelBook.WorkSheets(1).cells(1,2).value="SN"
ExcelBook.WorkSheets(1).cells(1,3).value="SN"
ExcelBook.WorkSheets(1).cells(1,4).value="SN"
ExcelBook.WorkSheets(1).cells(1,5).value="SN"
ExcelBook.WorkSheets(1).cells(1,6).value="SN"
ExcelBook.WorkSheets(1).cells(1,7).value="SN"
ExcelBook.WorkSheets(1).cells(1,8).value="SN"
ExcelBook.WorkSheets(1).cells(1,9).value="SN"
ExcelBook.WorkSheets(1).cells(1,10).value="SN"
cnt=2
do while not rs.Eof
ExcelBook.WorkSheets(1).cells(cnt,1).value=rs.fields("SN").value
ExcelBook.WorkSheets(1).cells(cnt,2).value=rs.fields("PN").value
ExcelBook.WorkSheets(1).cells(cnt,3).value=rs.fields("TEST_Temp").value
ExcelBook.WorkSheets(1).cells(cnt,4).value=rs.fields("DDM_BIAS").value
ExcelBook.WorkSheets(1).cells(cnt,5).value=rs.fields("DDM_TXPWR").value
ExcelBook.WorkSheets(1).cells(cnt,6).value=rs.fields("TX_PWR").value
ExcelBook.WorkSheets(1).cells(cnt,7).value=rs.fields("TX_ER").value
ExcelBook.WorkSheets(1).cells(cnt,8).value=rs.fields("RX_SEN").value
ExcelBook.WorkSheets(1).cells(cnt,9).value=rs.fields("LOS_AST").value
ExcelBook.WorkSheets(1).cells(cnt,10).value=rs.fields("LOS_DAST").value
rs.movenext
cnt = cint(cnt) + 1
loop
Excelbook.SaveAs("../dataExcel/order.xls")
wscript.sleep 3000
ExcelApp.Application.Quit '导出以后退出Excel
Set ExcelApp = Nothing '注销Excel对象
Excelbook.SaveAs("../dataExcel/order.xls")
不报错,但是没有生成对应文件
初入手请大佬知道