Results 1 to 10 of 10

Print files with macro in Order!

Threaded View

  1. #1
    Registered User
    Join Date
    09-15-2020
    Location
    Lithuania
    MS-Off Ver
    2019
    Posts
    84

    Print files with macro in Order!

    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



    RE01.jpg
    Attached Files Attached Files
    Last edited by windzz; 09-30-2020 at 03:05 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Print PDF files in a specific order using shell
    By DJohnny in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-17-2022, 06:29 AM
  2. Need macro to print pages in a range in reverse order
    By luajambeiro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-29-2019, 09:47 AM
  3. Rename all files in the same folder then print in order?
    By HXIO in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-10-2018, 09:20 AM
  4. [SOLVED] print pages in specific order in vba macro
    By pongmeister in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-18-2016, 12:33 PM
  5. Print macro printing sheets in wrong order
    By j.farr3ll in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-08-2011, 09:12 AM
  6. Print order for range in macro
    By JanineLeMaster in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-16-2007, 05:51 PM
  7. Print Macro Needed - Specified Order of Worksheets.
    By iwgunter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2005, 12:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1