We help IT Professionals succeed at work.

Xlsx files no longer print in sequential order

Wilf
Wilf used Ask the Experts™
on
The process is that one department creates serialized invoices in Excel  and saves them to a USB drive.  The next department takes the USB drive, highlights the invoices, right clicks and chooses print.  When the invoices were created on the computer running Windows 7 Pro and Office 2010, the files would be printed in sequence based on the file name.  Both computers were running Windows 7 Pro and Office 2010.

Both computers were upgraded to Windows 10 Pro, and Office 365.

Now when the same process is used, the invoices are no longer printed in sequence.  There does not seem to be any rhyme nor reason to the order they are printed in.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
NoahHardware Tester and Debugger

Commented:
Hi there! :)

On the computer you want to print the items, try running this on Powershell. You will need to replace the C desktop location with your USB location.

$FilesToPrint = Get-ChildItem "C:\users\test\desktop\test docs" -Recurse -Include *.xlxs

foreach($File in $FilesToPrint)
{
Start-Process -FilePath $File.FullName -Verb Print -PassThru | %{ sleep 10;$_ } | kill
}

Open in new window

Author

Commented:
Will try in two days

Author

Commented:
I think the script improved items, but I ran a quick test on the first four items, and it did 18 19 21 and then 20.  

This is better than before, and it would appear that it is giving the value 0 the highest rating [>1]
invoice-numbers.PNG
Hardware Tester and Debugger
Commented:
Hi there! :)

In that case, please try out this software.

Reference: https://www.print-conductor.com/

Here is an example video. You can sort the files in the order you want and print them after importing the folder.

Reference: https://www.youtube.com/watch?v=m8jJ5B_2F6o&feature=youtu.be

Author

Commented:
Thanks for your patience.  The first answer was helpful, but the program will probably make most sense
NoahHardware Tester and Debugger

Commented:
You're welcome! Glad I was of help :)