我通过excel打印票据,将打印代码放在循环中for i = 0 to PrintCnt - 1 Step 1
...
With objxlsWorksheets .Cells(1, 2).Value = Data(i) '往excel里写数据
...
End with
...
icount = ????? '插入数据后,返回需要打印的页数(PageCount) objxlsWorksheets.PrintOut '通过excel打印 objxlsWb.Close False
bjxlsApp.Quit
Set objxlsWs = Nothing
Set objxlsWb = Nothing
Set objxlsApp = Nothing
...Next请问,插入数据后,怎样才能返回打印的页数(PageCount)小弟急盼!! 谢谢!!
...
With objxlsWorksheets .Cells(1, 2).Value = Data(i) '往excel里写数据
...
End with
...
icount = ????? '插入数据后,返回需要打印的页数(PageCount) objxlsWorksheets.PrintOut '通过excel打印 objxlsWb.Close False
bjxlsApp.Quit
Set objxlsWs = Nothing
Set objxlsWb = Nothing
Set objxlsApp = Nothing
...Next请问,插入数据后,怎样才能返回打印的页数(PageCount)小弟急盼!! 谢谢!!
ActiveWindow.SelectedSheets.PrintOut Copies:=3, Collate:=True这个是打印1-2页共三份
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=2, Copies:=3, Collate _
:=True