Forum Discussion
A_SIRAT
Jun 16, 2022Iron Contributor
Enhancing an existing VBA code to automate Printing
Hi,
I have this file that I use to extract specific Delivery orders from a large worksheet and thereafter the VBA simplifies the process. The VBA does two things :
1.When I manually enter a Delivery number in cell E7 (Delivery_Number), the data is pulled from the related worksheet (not included) and makes it ready to Print.
2. The VBA also has a Process Batch function which looks up the Delivery Numbers from Sheet1 and process them in the same manner. With both functions, I have to press print for each and every order.
My request is to be helped to enhance the VBA code to make it print all the orders listed in Sheet1 in one SINGLE click directly to the selected printer eg. If for example at the first instance, I select Adobe PDF as my printer and also choose a desired save location, then the Deliver orders will be printed separately and saved to the specified location using the Delivery numbers in sheet 1 or any other possible naming sequence. If I choose a HP LaserJet Printer, then they will all be printed (Hard copies) on the Printer.
I have attached the file.
No RepliesBe the first to reply