导出数据的代码,在发布之前可以正常导出 编译之后点导出 出现
此主题相关图片如下:2.png
![dvubb 图片点击可在新窗口打开查看](UploadFile/2015-7/2015791547988384.png)
导出代码如下
Dim flg As New SaveExcelFlags
flg.RowNumber = False
flg.CellStyle = False
Tables("订单组订单查询_mb").SaveExcel(ProjectPath & "test.xls","原始数据",flg)
Dim App As New MSExcel.Application
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(ProjectPath & "test.xls")
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets("待导入数据")
Dim Rg As MSExcel.Range = Ws.UsedRange
rg.Formula = rg.Formula
app.visible = True