excel to pdf print

[Borut]

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?

[Logit]

.
ActiveSheet.PageSetup.Orientation = xlLandscape

[Borut]

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

[Paul_Hossler]

I usually do it like this



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

[Borut]

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

[Logit]

.
https://stackoverflow.com/questions/23118877/save-as-pdf-in-landscape

[Borut]

not working.

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

[Paul_Hossler]

1. Can your printer print landscape?

2. What program are you using to print?

3. Adobe Reader does it just fine

27398

[Borut]

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

[Logit]

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

[Borut]

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