列印第二頁

2007-03-30 7:06 pm
Excel檔案連續列印檔案中第二頁
例:檔案101.102.103.104105.祇需列印第二頁(我的Printer不能自動翻紙)
請告知方法或如何用電腦語寫下列印程式。
Thanks

回答 (2)

2007-03-30 7:20 pm
✔ 最佳答案
I think you can use the Excel macro. Click Tools, Macro, Record New macro.

Then you demonstrate opening a file and print only the page 2. Close the file.

Then you click stop button for recording macro. Click Tools, Macro, Macros. On the Macro window, click Edit to view the codes. You can modify it to what you want. Next time you just run the Macro to print page 2 for all your specified file.

Here is the sample I built:
Workbooks.Open Filename:= "D:\Temp\test.xls"
ActiveWindow.SelectedSheets.PrintOut From:=2, To:=2, Copies:=1, Collate:=True

Hope it helps.

You can email me if you need more help on it.
參考: Me
2007-03-30 7:17 pm
要列印時按 : 檔案 -> 列印 -> 選列印範圍 -> 頁數
如你只要列印第二頁, 你打 從 2 至 2 即可


收錄日期: 2021-04-12 20:31:56
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070330000051KK00863

檢視 Wayback Machine 備份