Save worksheet as a PDF and email as attachment

I have a code that temporarily saves a worksheet then attaches it to an email but I need it to be in pdf format.

Would anyone know how to do this?

It will not allow me to post the code as HTML is blocked

Thanks

Saves active sheet as PDF and emails

Please Login or Register  to view this content.

nigelog,

Thanks for the quick reply.

It gives me a run time error 1004 and highlights the line .ExportAsFixedFormat Type:=xlTypePDF, Filename:=PdfFile, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False

Is there something else I need to do?

my guess is you have no folder called Temp on C: drive - change this to suit

Please Login or Register  to view this content.

That's what it was thanks nigelog..

Can I change the name of the pdf on the attachment and can I get my email signature on the email?

Thanks nigelog

Glad to help and thanks for the feedback and rep