Print files with macro in Order!

[windzz]

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

 

[Isaac]

Should be moved to Excel forum?

 

[theDBguy]

Hi @windzz. Welcome to AWF!

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

 

[arnelgp]

try if it is fixed.

 

[windzz]

try if it is fixed.

Thank You for your answer @arnelgp.
My company is under quarantine since yesterday. Can't check if it works with their printer...
But i will give a feedback as soon as possible!

 

[arnelgp]

ok, stay safe!

 

[windzz]

@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]

then you need to talk to your it to configure your network printer to fix the Queueing of the printjobs.