Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Printing / November 2007

Tip: Looking for answers? Try searching our database.

JOb accounting problem printing from Excel -- HELP

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jason - 10 Nov 2007 09:29 GMT
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 - 14 Nov 2007 07:53 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.