• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Print files with macro in Order! (1 Viewer)

windzz

New member
Local time
Today, 11:45
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: 10

Isaac

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

theDBguy

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

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

arnelgp

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

Attachments

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

windzz

New member
Local time
Today, 11:45
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, 16:45
Joined
May 7, 2009
Messages
10,544
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