This code is used to send documents to the printer but when they get sent all at once I usually have to one of the documents so it prints
Here is the code that actually prints each file
How can i delay one or two of them to prevent failed prints?
VBA Code:
Call FilePrint("C:\Audit Reports\Compiled" + "\Night Audit " & Format(Date - 1, "mm-dd-yyyy") & ".pdf")
Call FilePrint("C:\Audit_Processing\Cash Deposit Log.xlsm")
Call FilePrint("C:\Audit_Processing\GM Packet Coversheet - IHG Limited Service.docx")
Call FilePrint("C:\Audit Reports\Disembodied\" + Format(Date - 1, "mm-dd-yyyy") + "\Out of Order.pdf")
Call FilePrint("C:\Audit Reports\Disembodied\" + Format(Date - 1, "mm-dd-yyyy") + "\Manager Report.pdf")
'End Sub
VBA Code:
ShellExecute Application.hwnd, "Print", strFilePath, 0&, 0&, SW_HIDE