Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2003
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Speed up printing multiple jobs in Excel (Excel 2003)

    I have a procedure that loops through and prints multiple changes in a spreadsheet. It seems that Excel waits to continue the application until the print job has completed. Is there a way to send the jobs to the print queue or spooler and continue with the procedure (The procedure would continue to change the spreadsheet and add more print jobs as it goes).

    Are there other ways to speed up the printing (each print job is a single page, but the same sheet).

    Thanks!

    Stephen

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Speed up printing multiple jobs in Excel (Excel 2003)

    Unlike Word, Excel doesn't support printing in the background, so your macro will wait until a print job has been sent off to the printer before continuing.

  3. #3
    New Lounger
    Join Date
    Sep 2003
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Speed up printing multiple jobs in Excel (Excel 2003)

    Thanks

Posting Permissions

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