Thread: setprintquality
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default setprintquality

If you were to read ALL the text on the site you posted below you would find a
link to obtaining the HotFix from MS support.

To resolve this problem immediately, contact Microsoft Product Support Services
to obtain the hotfix. For a complete list of Microsoft Product Support Services
telephone numbers and information about support costs, visit the following
Microsoft Web site:
http://support.microsoft.com/contactus/?ws=support

Note: also carefully read the part about prerequisites for installing the HotFix


Gord Dibben MS Excel MVP


On Sat, 17 Mar 2007 13:44:00 -0700, excel-tr
wrote:

hi,

Run-time error '1004':

"Unable to set the PrintQuality property of the PageSetup class."

when I run the below code, I get above error, for this there is hotfix but
from where I can download it ?
http://support.microsoft.com/kb/903246 no file in this link

Sub SetPrintQuality()

For Each xSheet In ActiveWorkbook.Sheets
xSheet.PageSetup.PrintQuality = 300
Next xSheet

End Sub