Results 1 to 2 of 2
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Updating Headers / Footers (Excel 2003 VBA)

    We have been working on an excel model recently at work and part of that involves automatically updating the headers and footers. I've noticed that this process takes a long time (30 sec for 30 sheets) and appears to be linked to the printer (somehow).

    Is there a way of speeding this up?
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

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

    Re: Updating Headers / Footers (Excel 2003 VBA)

    Any code involving PageSetup in Excel VBA is very slow. There is a workaround that uses the ExecuteExcel4Macro method of the Application object. See <post#=177205>post 177205</post#>.

Posting Permissions

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