Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hooking into Print function for trays (2002)

    We receive a vast number of externally sourced documents that specify printer trays. This wastes our letterhead and creates multiple issues. I want to stop it happening by detecting tray settings and doing something about it.

    I'm looking to 'hook' into the print function using VBA. I'm happy enough coding the tray related code. My issue is creating the generic routine that works for any document as it is printed.

    As I understand it I need to create a routine with the same name as the standard function in Normal.dot
    Can someone please describe the where and what?

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

    Re: Hooking into Print function for trays (2002)

    I think you'll have to use the DocumentBeforePrint event of the Application object. See <post#=217332>post 217332</post#>. Or create FilePrint and FilePrintDefault macros. See the same thread <img src=/S/grin.gif border=0 alt=grin width=15 height=15>.

  3. #3
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hooking into Print function for trays (2002)

    Hans Thanks for the reference - I'll have a play but on a first read it looks just right
    Andrew

Posting Permissions

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