Excel VBA and printer settings?

[fporterAECI]

Does anyone know how to change the settings of the Active Printer using VBA code? I made a "batch" worksheet printing program to print a bunch of different worksheets in a workbook auto. But when you use the .PrintOut method for printing, it uses the current settings of the active printer to print. I'm wanting to be able to change the printing resolution from 300 dpi to 600 automatically. I've tried calling up the built-in dialog (xlDialogPrint) and sending keys to it, but the problem is that while the dialog is up, my code is paused. There has to be a way to do this, even if it involves calling a Windows API function. Can anyone help?
Thanks!

 

[Mala]

Try inserting the line:
ActiveSheet.PageSetup.PrintQuality = 600
in the appropriate place

If the sheet being printed is assigned to an object variable, say 'Sht' then you would use:
Sht.PageSetup.PrintQuality = 600

 

[fporterAECI]

okay, I'll try that thanks!!