Print files with macro in Order! (1 Viewer)

windzz

New member
Local time
Today, 11:16
Joined
Oct 2, 2020
Messages
3
Hello,

I am trying to make a team macro in Excel:
1st Macro gets Folder Path by selecting location of folder.
Then in excel, there are lines, that fill in the file names (for example all PDF.'s that are in the folder)
2nd Macro is called Print Loop. It goes trough the array of file names, and sends them to the Printer to print.
Macro works, but only problem:
When printer prints, it mixes the sheets. It is a total chaos! Is it possible to send some feedback to macro from printer, or to make macro work so that it would keep the order of file named and printed files ?

I attach the Macro excel file. Everything is under "Print_Files" sheet

1601663710207.png
 

Attachments

  • SMART PRINT EXCEL.zip
    28.8 KB · Views: 16

Isaac

Lifelong Learner
Local time
Today, 01:16
Joined
Mar 14, 2017
Messages
2,693
Should be moved to Excel forum?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 01:16
Joined
Oct 29, 2018
Messages
13,163
Hi @windzz. Welcome to AWF!

I have moved your topic to the Excel Forum as suggested.
 

arnelgp

error reading drive A:
Local time
Today, 17:16
Joined
May 7, 2009
Messages
10,844
try if it is fixed.
 

Attachments

  • SMART PRINT EXCEL.zip
    35.7 KB · Views: 19

windzz

New member
Local time
Today, 11:16
Joined
Oct 2, 2020
Messages
3
@arnelgp , thank you for your effort in this code!
i tried it and if the printing pages are within one pdf, everything prints in order.
but the problem still remains with overall order of pdf sequence. all pdf's are printed in random order still.
 

arnelgp

error reading drive A:
Local time
Today, 17:16
Joined
May 7, 2009
Messages
10,844
then you need to talk to your it to configure your network printer to fix the Queueing of the printjobs.
 

Users who are viewing this thread

Top Bottom