+ Reply to Thread
Results 1 to 2 of 2

Printing Macro in Word

  1. #1
    Registered User
    Join Date
    09-12-2008
    Location
    Gloucester
    Posts
    8

    Printing Macro in Word

    Afternoon everyone.

    I have been trying to setup three different Printing Macros for our end users under Micrsofot Word.

    What we have - Legal Print out, A4 Print out and Letter Print out. I made a custom toolbar for printing by using Macro, with each one set to certain page scale (i.e. Legal, A4 or Letter), certain tray and a printer.

    The problem with the macros is that it prints the whole document once clicked instead of opening a Print Dialog box.

    I re-wrote the macro like:
    Please Login or Register  to view this content.
    Although now when user clicks onto the Print button, it pops up the printer dialog box but it doesn't set the scale to Paper size = "Legal" even though I have mentioned it into the code.

    I think what I need is to set the Printer.PageSize=wdPaperLegal but it doesn't work.

    Could someone please help me in this situation?

    Summary:
    1: Set a printer to certain printer - which I have done
    2: Set a printer to certain Page Size (Legal, A4, Letter) - Can't do for some reason
    3: Set a printer to a certain Printer Tray - need to set to printer tray 2 but don't know how to do it.

    Many thanks

    Regards

    Jehanzeb

  2. #2
    Registered User
    Join Date
    12-09-2009
    Location
    Washington, DC
    MS-Off Ver
    Excel 2002
    Posts
    2

    Re: Printing Macro in Word

    Here is some code that I modified from from several sources

    Please Login or Register  to view this content.
    In another procedure you would call the SetPrinter Function, for example

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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