excel to pdf print

Hello,

I like to have landscape orientation pdf (when select "file", and "print "). In Excel is ok. When I run macro, pdf is ok (landscape)
But when I select print, orientatiov is Portland, not landscape

IncludeDocPropertis:=True doesnt work.

It possible to force landcape orientation to print setup?

.
ActiveSheet.PageSetup.Orientation = xlLandscape

not working. When selected in pf file, print, pagesetup, orienatation in Portland. Beacuse my page is landscap, must be printed landscape (pdf print).

I usually do it like this

Code:

---

Sub Example1()
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Users\Me\Documents\test3.pdf", _
        Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
        OpenAfterPublish:=False
End Sub

---

Yes, code is the same. PDF (when I open with maro) is ok, orientation landscape. If I liked too print it, must manual select landscape orientation.
I try some codes from internet, but nothing Works

.
https://stackoverflow.com/questions/...f-in-landscape

not working.

PDf is landscape orientatio. but when I select icon "printer", is Portland orientation. I can not force lanscape orientation

1. Can your printer print landscape?

2. What program are you using to print?

3. Adobe Reader does it just fine

Attachment 27398

1.yes, I can print landscape
2. I open pdf with pdf adobe acrobat
3. in excel, is landscape orientation, when I convert to pdf, pdf is landscape orientation.
But when click print, is marked Portland (print window is the sama as yours).
I dont know why

.
Here's a stab in the dark ... update your printer drivers.

I remove page breaks and add rows, that the page is full (excel separate pages). only this help