Override excel's printing dpi setting
 

This question has been asked before, but not answered. So here goes
again:

I need to programmatically print excel documents based on the printer's
settings (essentially the dpi). However, for excel documents, they have
their own print settings in Page Setup. When printing programmatically,
these settings override the printer's default settings.

Any ways to change the document's settings, or to override these
settings to use the printer's, or even to intercept the print job to
change them?

Thanks!