Results 1 to 3 of 3
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Print Setup Slow (VBA/Excel/2003)

    The last thing my app does is grab all the stuff from the UserForm and plop (technical term) it down on a new workbook. That part runs in milliseconds. Then I start "Page Setup" to make it pretty like the client wants and it slows to a crawl. I have chopped out the options in the Setup that are not pertinent; but it still crawls.

    Is there an easy cure?
    Alan

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

    Re: Print Setup Slow (VBA/Excel/2003)

    Accessing the PageSetup object in VBA is notoriously slow. Jan Karel <!profile=Pieterse>Pieterse<!/profile> posted a workaround in <post#=177205>post 177205</post#>.

  3. #3
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Print Setup Slow (VBA/Excel/2003)

    Looks great! Thanks!

    <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>
    Alan

Posting Permissions

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