changing printer.papersize=vbPRPSLetter (1 Viewer)

[areddy]

Dear All,

Iam opening an excel file through visualbasic6.0 code with some data iam filling in the excel file.everything is ok but i want to change the printer papersize A4 to Letter.
iam setting to Printer.papersize=vbPRPSLetter for Letter in the visual basic code.

but it is not setting to Printer.papersize =vbPRPSLetter

please helpme on this regard...

Thanks a lot !!!
Amar...