Consulting

Results 1 to 4 of 4

Thread: Printing Macro

  1. #1
    VBAX Newbie
    Joined
    Oct 2006
    Posts
    3
    Location

    Printing Macro

    I am trying to get a print macro for Word XP that will let me print a document to headed paper in tray 1 and then to plain paper in tray 2, can anyone give me any help on this?

    Thanks

    Simon.

  2. #2
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Hi Simon,
    Welcome to VBAX
    Here's a simplified version of what I use. You'll need to determine the correct constant values for your printer, which you can do by recording a macro changing the paper source in Page Setup. The Userform format gives much more flexibility and options than individual macros.

    I also created a KB item for changing printers which may be of interest if you need watermark etc. options.
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  3. #3
    VBAX Newbie
    Joined
    Oct 2006
    Posts
    3
    Location
    Thanks for that, I have opened the document but I am unable to edit the macro as it does not appear in the macro list. May be a stupid question but how do I edit the Macro?
    Simon.

  4. #4
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    The code is contained in a Userform
    Press Alt + F11 to enter the Visual Basic Editor (VBE)
    In the Left pane, within the Project should be a Forms folder. Open this folder.
    There should be a form PrintSelector. Select this and click View/Code.
    Remember to save your changes on completion.
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

Posting Permissions

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