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,
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
Jason - 14 Nov 2007 14:17 GMT
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,
> Are you able to access & post the VBA code?
[quoted text clipped - 11 lines]
>
> Jason