Sub print_print()
Application.ScreenUpdating = False '禁用屏幕刷新
Dim wk As Workbook
Dim i As Integer
For i = 2 To Range("b2").End(xlDown).Row '循环单元格区域
Set wk = Workbooks.Open(ThisWorkbook.Path & Application.PathSeparator & Range("b" & i).Value & ".xlsx") '打开对应表格
wk.PrintOut Copies:=1, Collate:=True, IgnorePrintAreas:=False '打印表格
wk.Close '关闭表格
Next
Application.ScreenUpdating = True
End Sub
Sub print_print()
Application.ScreenUpdating = False '禁用屏幕刷新
Dim wk As Workbook
Dim i As Integer
For i = 2 To Range("b2").End(xlDown).Row '循环单元格区域
Set wk = Workbooks.Open(ThisWorkbook.Path & Application.PathSeparator & Range("b" & i).Value & ".xlsx") '打开对应表格,地址(红色部分,最后处别带\号)请修改为你存放表格的地址
wk.PrintOut Copies:=1, Collate:=True, IgnorePrintAreas:=False '打印表格
wk.Close '关闭表格
Next
Application.ScreenUpdating = True
End Sub
Sub print_print()
Application.ScreenUpdating = False '禁用屏幕刷新
Dim wk As Workbook
Dim i As Integer
For i = 2 To Range("b2").End(xlDown).Row '循环单元格区域
Set wk = Workbooks.Open(ThisWorkbook.Path & Application.PathSeparator & Range("b" & i).Value & ".xlsx") '打开对应表格,地址(红色部分,最后处别带\号)请修改为你存放表格的地址
wk.PrintOut Copies:=1, Collate:=True, IgnorePrintAreas:=False '打印表格
wk.Close '关闭表格
Next
Application.ScreenUpdating = True
End Sub