è¯·ä½ å°æ件åå¨CMDä¸ç¨DIR *.DOC>AAA.txtå½ä»¤å
¨é¨ä¿åå°AAA.txtæ件 ä¸ï¼åç¨EXCELæå¼è¿æ件ï¼ååï¼å é¤é¤æ件åå¤çææå
容ï¼æ件åæ¾AåA1å¼å§ï¼æ§è¡ä¸åVBAç¨åºï¼éä¸è¯»å
¥æ件åï¼æå¼ï¼æå°ç¬¬4页ï¼å
³éæ件ã
Sub å®1()
Dim intLastRow, arr, intLoop
intLastRow = Cells(Rows.Count, 1).End(xlUp).Row
arr = Range("a1:b" & intLastRow)
For intLoop = 1 To UBound(arr)
Open "D:\FILE\" & arr(intLoop, 1) & ".doc" For Output As #1
Application.PrintOut FileName:="", Range:=wdPrintRangeOfPages, Item:= _
wdPrintDocumentWithMarkup, Copies:=1, Pages:="4", PageType:= _
wdPrintAllPages, Collate:=True, Background:=True, PrintToFile:=False, _
PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0, _
PrintZoomPaperHeight:=0
Close #1
Next
End Sub
å¦ä¸ä¸ªæ¹æ³æ¯è±é±å°æåç¤¾è¯·äººå¸®ä½ éä¸æå°ã
温馨提示:答案为网友推荐,仅供参考