Using VBA to create PDF - setting paper size

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
 
R

Ron de Bruin

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
 
F

Felipe Dex

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top