• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Send as pdf

B

bradpallister

New Member
Hullo

I need to send a worksheet by email ie SendEmail, but it needs to be as pdf.

Any ideas? I need to keep the original xlxs format, but I will not need the pdf once its been emailled.

Hope it makes sense, appreciateit if anyone has any sample code to sort.

cheers
 
You don't save a file as a PDF file,

But you can print some areas or all the file as a PDF file


There are lots of free PDF writers available on the net, look them up and install one

Then just print to a PDF file selecting the PDF printer as your printer


Some versions of Excel 2007/2010 can save as PDF

Check yours on the Save As menu
 
Brad,


Considering you are using Excel 2007 an above... you can use the below to save as PDF


ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _

"C:Book1.pdf", Quality:= _

xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _

OpenAfterPublish:=False


HTH

~Vijay
 
You must log in or register to reply here.
Back
Top