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
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