Sending Excel Worksheet as PDF file with Excel 2007

[Alain-79]

While having an Excel file opened, I am testing that code for this
ActiveSheet.ExportAsFixedFormat type:=xlTypePDF, _
fileName:=CStr(SaveAs_path & SaveAsPdf_offerName), _
Quality:=xlQualityStandard, _
IncludeDocProperties:=False, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=False
Application.Dialogs(xlDialogSendMail).Show

but the only thing I get attached to the email opened is the Excel file
itself, not the pdf file

I got this code from the recorder while doing a send as PDF file with Excel
2007... The function is working while used frome Excel itself, not while
replaying the code generated... The only difference I can figure out is that
while done from excel, the pdf file is saved under a temp directory under
your profile...

Any idea why it is not working ?
Have not found clear explanation about the code
Application.dialogs(xlDialogSendMail).Show

Thanks for your help
Alain

 

[Barb Reinhardt]

This should help you.

http://www.rondebruin.nl/pdf.htm

 

[Alain-79]

I have had a look to the code of Ron and see that he is not using the
Application.dialogs(xldialogSendMAil).show method

does it mean it is not a "recommended" method?

Alain

 

[Ron de Bruin]

Hi Alain

It is not possible to add other files(other then the activeworkbook) with code if you use SendMail.
If you use the Outlook object model it is possible