Sending Excel Worksheet as PDF file with Excel 2007
 

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

Sending Excel Worksheet as PDF file with Excel 2007
 

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

Sending Excel Worksheet as PDF file with Excel 2007
 

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

Sending Excel Worksheet as PDF file with Excel 2007
 

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