.PrintQuality = 600

[Miskacee]

I have a spreadsheet which runs fine whenever i run it. whenever someone
runs it, they get an error on : .PrintQuality = 600 and says unable to set
the print quality property of the page setup class. i compared her
option/setup and all is the same as what i have. any suggestions on why the
person is getting this error?

Thanks for your help!

 

[ker_01]

That sounds like something that would be dependent on the capabilities of the
print driver for the default printing device. If you (or she) manually sets
up a document to print, what is the default printer, and what is it's highest
available resolution? Most modern printers allow for higher resolution, but
older printers, generic print drivers, or "electronic document" print drivers
may be limited to a lower number (300?).

Possible workaround:
<code>
..printquality = 300
on error resume next
..printquality = 600
on error goto 0
<code>

HTH,
Keith

 

[Dave Peterson]

You could ignore the error (on error resume next) or try to work around it (like
Keith shows).

Or you could just weasel out and assume that most print jobs won't need to be
told the .printquality property (just drop the line from your code).

You may want to be more concerned with margins. I try to make them as wide as I
can for the worst(!) possible printer I could imagine.

 

[ker_01]

To follow up on Dave's comment, my workaround actually wasn't thought out
well enough. It may be possible that some print driver simply doesn' accept
any value you'd want to set, so you'd want both lines within the
error-ignoring lines (see correction below). Still, if it isn't required,
then like Dave said, see if you can just drop it altogether...

Possible workaround:
<code>
on error resume next
..printquality = 300
..printquality = 600