Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Excel4 PAGE.SETUP (XL2003 VBA)

    I read that using the old PAGE.SETUP XLM function is much quicker than changing the properties of the PageSetup object (in the very excellent Professional Excel Development book). However the properties that I typically need to set are PrintArea, PrintTitleRows, and PrintTitleColumns - none of which seem to be included. Am I missing something, or do they have to be set in VBA after all?
    TIA

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

    Re: Excel4 PAGE.SETUP (XL2003 VBA)

    There are separate macro functions for this: SET.PRINT.AREA and SET.PRINT.TITLES.

    For example:
    <code>
    Application.ExecuteExcel4Macro("SET.PRINT.AREA(""A 110"")")
    </code>
    But do you really need this? Although it's true that the old Excel macro commands are faster, you won't notice much difference with today's very fast computers.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Excel4 PAGE.SETUP (XL2003 VBA)

    Thanks. And point taken about the speed issue. I'll check it out and if it makes little difference I'll leave it as is (in the interests of maintainability).

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

    Re: Excel4 PAGE.SETUP (XL2003 VBA)

    If you decide to use the Excel 4 macro functions, the help file describing them is still available for download from Microsoft: Macrofun.exe File Available on Online Services

Posting Permissions

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