K
Keithlo
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
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