+ Reply to Thread
Results 1 to 4 of 4

Speeding up code to export spreadsheets as PDF's

  1. #1
    Valued Forum Contributor
    Join Date
    11-12-2014
    Location
    Nottingham
    MS-Off Ver
    2013
    Posts
    383

    Speeding up code to export spreadsheets as PDF's

    Hi all,

    Been a while since I've posted...

    I'm hoping to get a few hints on how to speed my code up... It is running through approximately 180 pupils to print off some exam analysis sheets to help them but taking a while to run! Any advice would be appreciated as I can't say I'm an expert in VBA!

    Please Login or Register  to view this content.
    Thanks in advance!
    ARowbot
    !If all your troubles are solved, then so is the thread. Show this by marking it so using thread tools at the top of the page.
    If I helped do this, then please show your appreciation by awarding rep points.
    <------ Button for that is over there

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Speeding up code to export spreadsheets as PDF's

    It might help if you saved each pupil to a worksheet and then just printed the entire workbook.

  3. #3
    Valued Forum Contributor
    Join Date
    11-12-2014
    Location
    Nottingham
    MS-Off Ver
    2013
    Posts
    383

    Re: Speeding up code to export spreadsheets as PDF's

    I did consider that...However I have some conditional formatting and formulas in there which are affected if I move it to another sheet. I've attached a template document now that I have removed sensitive data.
    Last edited by ARowbot; 03-26-2017 at 05:35 AM.

  4. #4
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Speeding up code to export spreadsheets as PDF's

    I came across something ... Are you using a networked printer? If so, try a local printer.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help speeding up matching code
    By rscott29 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-30-2015, 08:28 AM
  2. [SOLVED] Speeding Up Code
    By ScabbyDog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2013, 11:52 AM
  3. Help speeding up code please
    By AJC2012 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2013, 05:17 PM
  4. Speeding up a code
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 06-25-2012, 10:50 AM
  5. Speeding up code
    By n1210933 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-23-2010, 11:25 AM
  6. I Need Help Speeding Up code
    By deeppurple247 in forum Excel General
    Replies: 2
    Last Post: 02-25-2007, 07:01 PM
  7. [SOLVED] Speeding Up Code
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-31-2005, 12:05 PM

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