Hello to all,
I made a Excel vba code that sends pdf files one by one to a user specified printer and prints them out.
The code works and all the files are printed, but I still have a problem with the order of the printout files. I think this is because of the network connection and the time it takes for the printer to receive the file, add it in queue and print it.
I tried to use "application.wait now" for 4 seconds before sending the next file to the printer, but it doesn't always get the desired result.
I also added a "application. wait now" for 30 seconds when the number of printed files is a multiple of 10.
Is there a way to receive a response from the printer, that it received the command to print for file "1.pdf", so that I can tell shell to execute the next command?