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

This should help you.

http://www.rondebruin.nl/pdf.htm
--
HTH,

Barb Reinhardt



"Alain-79" wrote:

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

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

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Alain-79" wrote in message ...
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