专家坐堂-[求助]exec模板打印怎么自定义纸张大小？Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

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("打印完成!","提示")