ok, 1st post, here goes...
I have a macro where I can open multiple sheets, print a specific tab, close the sheet and move on to the next one until they are all done. Problem is I need to open so many it bogs down the pc.
Can I select all to be printed and print a specific tab without actually opening the file?
Or...
Can I select all to be printed, have them open, print, close one at a time?
here is my current code:
Sub PRINT_AUDIT()
Application.FindFile
Application.DisplayAlerts = False
For Each Workbook In Workbooks
Sheets("Margin Summary").PrintOut
ActiveWindow.Close
Next
End Sub
I have a macro where I can open multiple sheets, print a specific tab, close the sheet and move on to the next one until they are all done. Problem is I need to open so many it bogs down the pc.
Can I select all to be printed and print a specific tab without actually opening the file?
Or...
Can I select all to be printed, have them open, print, close one at a time?
here is my current code:
Sub PRINT_AUDIT()
Application.FindFile
Application.DisplayAlerts = False
For Each Workbook In Workbooks
Sheets("Margin Summary").PrintOut
ActiveWindow.Close
Next
End Sub