如题,现在代码如下,求大侠帮忙修改:
Dim Book As New XLS.Book(ProjectPath & "Attachments\地磅单.xls")
Dim fl As String
fl = ProjectPath & "Reports\地磅单.xls"
Dim sql2 As String
sql2 = "查询语句"
book.AddDataTable("B","GM",sql2)
Book.Build()
Book.Save(fl)
Dim App As New MSExcel.Application
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(fl)
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)
App.Caption = "地磅单"
App.PrintCommunication = False
With Ws.PageSetup
.CenterHorizontally = True '页面水平居中
End With
App.PrintCommunication = True
App.Visible = True
Wb.Save()
Wb.Close()
Ws.PrintPreview(True)
App.Quit
MessageBox.Show("打印完成!","提示")