-
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
-
-
not working.
PDf is landscape orientatio. but when I select icon "printer", is Portland orientation. I can not force lanscape orientation
-
1 Attachment(s)
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