Sub test()
Set rrr = CreateObject("Scripting.FileSystemObject")
Set r = rrr.GetFolder("D:\打印\")
For Each i In r.Files
Workbooks.Open Filename:=("D:\打印\" + i.Name + "")
ActiveSheet.Columns("A:H").ColumnWidth = 10.75
ActiveSheet.PageSetup.PrintArea = ""
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
ActiveWindow.Close saveChanges:=False
Next
End Sub
通过VBA实现
Sub test()
Set rrr = CreateObject("Scripting.FileSystemObject")
Set r = rrr.GetFolder("D:\打印\")
For Each i In r.Files
Workbooks.Open Filename:=("D:\打印\" + i.Name + "")
ActiveSheet.PageSetup.PrintArea = ""
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
ActiveWindow.Close saveChanges:=False
Next
End Sub
Sub test()
Set rrr = CreateObject("Scripting.FileSystemObject")
Set r = rrr.GetFolder("D:\打印\")
For Each i In r.Files
Workbooks.Open Filename:=("D:\打印\" + i.Name + "")
ActiveSheet.Columns("A:H").ColumnWidth = 10.75
ActiveSheet.PageSetup.PrintArea = ""
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
ActiveWindow.Close saveChanges:=False
Next
End Sub