Set PrintOut to print excel in color

G

Gary

I am printing excel files from MS Access for a while.

I have not had this problem, but it just happen with someone using my code.
They tried using my code to print some excel files and they are coming out in
B&W and not color.

When I do it, its printing in color (acrobat psuedo printer). I have made
sure the excel files are set to print in color using their printer. I have
the driver loaded only on my system. They are able to print a report (which
I can set to default printer), and it comes out in color.

This is the vba code I am using:

Set xlBook = xlApp.Workbooks.Open(Path & filename & ".xls")
Set xlSheet = xlBook.Worksheets(1)
xlSheet.PrintOut
xlBook.Close (False)
xlApp.Quit


Thank You,

Gary
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top