Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Code Prompts for Multiple Copies (2002 sp2)

    When printing multiple copies of Excel spreadsheets the printer prompt for the printer's "Access Code" once for each copy. The Access Code is the printer's way of tracking usage by employees. In Word, the Access Code is only prompted one time, regardless of the number of copies.

    I have had no luck figuring a work around on the printer side, does anyone have an explanation that I can give my customer as to why Excel's behavior is different than Word's?

    Thanks for any input.
    egghead

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Code Prompts for Multiple Copies (2002 sp2)

    Obviously Excel send the number of copies as separate print commands. Maybe you can work around this by setting the number of copies in the printer driver itself (click "Properties" on the print screen and find whether you can for that printer)?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Code Prompts for Multiple Copies (2002 sp2)

    Thanks for the response. I did try that. Once I set it in the driver and got back to the print dialog box, it had changed the number of copies there, too, with the same result. <img src=/S/disappointed.gif border=0 alt=disappointed width=15 height=15>
    egghead

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

    Re: Access Code Prompts for Multiple Copies (2002 sp2)

    Thanks for sharing what you found!

  5. #5
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Code Prompts for Multiple Copies (2002

    I finally found some information on this on Microsoft's website. Here's the article for anyone else who might need it:
    [Edit: shortened URL to avoid screen scrolling - Rory]
    Q162152
    egghead

Posting Permissions

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