Dim xls As New Excel.Application 'EXCEL应用程序对象 Dim xbook As Excel.Workbook 'EXCEL工作薄对象 Dim xsheet As Excel.Worksheet 'EXCEL工作表对象 Set xbook = xls.Workbooks.Add Set xsheet = xbook.Worksheets(1) '对xsheet操作,填充单元格 '……With xsheet.PageSetup .PaperSize = xlPaperA4'A4纸 .Orientation = xlLandscape'横向 .CenterHeader = "&""宋体,常规""&14表头" .CenterFooter = "&""宋体,常规""&P" End With xls.Visible = True'显示Excel xsheet.PrintPreview'打印预览'……
打印机对象Printer有众多的属性,你可以通过它进行打印机设置,也可以利用通用对话框控件的打印机设置功能设置打印机。
Dim xbook As Excel.Workbook 'EXCEL工作薄对象
Dim xsheet As Excel.Worksheet 'EXCEL工作表对象
Set xbook = xls.Workbooks.Add Set xsheet = xbook.Worksheets(1)
'对xsheet操作,填充单元格
'……With xsheet.PageSetup
.PaperSize = xlPaperA4'A4纸
.Orientation = xlLandscape'横向
.CenterHeader = "&""宋体,常规""&14表头"
.CenterFooter = "&""宋体,常规""&P"
End With
xls.Visible = True'显示Excel
xsheet.PrintPreview'打印预览'……