Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VBA to create PDF - setting paper size
I am successfully using Ron de Bruin's Create and mail PDF files with Excel
2007. Here is the relevant snippet from his function: Myvar.ExportAsFixedFormat _ Type:=xlTypePDF, _ FileName:=Fname, _ Quality:=xlQualityMinimum, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ OpenAfterPublish:=OpenPDFAfterPublish My questions is, where can I learn more of the above settings? Specifically, I would like to set the paper size to Legal. It's defaulting to Letter. But I would also like to know where I can learn all the parameters I can set this way for future reference. Thanks! Keith |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VBA to create PDF - setting paper size
Hi Keith
This are all the settings as far as I know and what you can find in the Help. The product is not perfect yet -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Keithlo" wrote in message ... I am successfully using Ron de Bruin's Create and mail PDF files with Excel 2007. Here is the relevant snippet from his function: Myvar.ExportAsFixedFormat _ Type:=xlTypePDF, _ FileName:=Fname, _ Quality:=xlQualityMinimum, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ OpenAfterPublish:=OpenPDFAfterPublish My questions is, where can I learn more of the above settings? Specifically, I would like to set the paper size to Legal. It's defaulting to Letter. But I would also like to know where I can learn all the parameters I can set this way for future reference. Thanks! Keith |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VBA to create PDF - setting paper size
Keith,
in a funny way, I'm trying to create a PDF in letter, but mine's defaulting to A4. I'm wondering if it is a setting of the system. Hope this's some clue. I'll keep trying to change. Best, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am trying to print on legal size paper, i cant set size. | Excel Discussion (Misc queries) | |||
Mattter typed on Legal paper want to get it on A4 size paper | Excel Programming | |||
create new paper size | Excel Worksheet Functions | |||
Setting paper size as variable for printing custom views | Excel Programming | |||
custom paper size setting | New Users to Excel |