JOb accounting problem printing from Excel -- HELP

Discussion in 'Excel Printing' started by Jason, Nov 10, 2007.

  1. Jason

    Jason Guest

    At our church, we use a Kyocera printer/copier. It is setup to use job accounting to track account codes for every print request. Everything works fine for all programs, except Excel. When printing multiple copies with Excel it prompts for the account code FOR EACH COPY. In other Office programs, it only asks once. Any ideas what is going on?

    We have called our Kyocera guy and he came out to take a look. He said it looks like a MS thing and that we should call Microsoft Support. I was hoping that someone might know something like this before we attempt phone support. I would really appreciate any advice anyone has to offer. Thanks.

    Jason
     
    Jason, Nov 10, 2007
    #1
    1. Advertisements

  2. Jason,
    Are you able to access & post the VBA code?




    At our church, we use a Kyocera printer/copier. It is setup to use job
    accounting to track account codes for every print request. Everything works
    fine for all programs, except Excel. When printing multiple copies with
    Excel it prompts for the account code FOR EACH COPY. In other Office
    programs, it only asks once. Any ideas what is going on?

    We have called our Kyocera guy and he came out to take a look. He said it
    looks like a MS thing and that we should call Microsoft Support. I was
    hoping that someone might know something like this before we attempt phone
    support. I would really appreciate any advice anyone has to offer. Thanks.

    Jason
     
    Roger Whitehead, Nov 14, 2007
    #2
    1. Advertisements

  3. Jason

    Jason Guest

    Sorry, that is beyond me. I am assuming you are talking about macros? We
    don't use any.

    What I have found out is that Excel makes a separate print job for each copy
    when "Collate" is checked. This is what causes the account code to be
    prompted for each time. We can turn the collate off, but it is an extra step
    that most of our "older" people continue to forget. I have not found a way
    to default the "Collate" to off. Is there a way we can default it or use a
    macro to turn it off at printing?

    Thanks for your response.

    Jason
     
    Jason, Nov 14, 2007
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.