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