Dim App As New MSExcel.Application
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open("D:\软件\Publish\Project\Reports\支出明细.xls")
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)
With Ws.PageSetup
.Orientation = MSExcel.xlPageOrientation.xlLandscape '横向打印
.CenterHorizontally = True '页面水平居中
End With
App.Visible = True
Ws.PrintPreview
App.Quit