Sending Excel Worksheet as PDF file with Excel 2007

  • Thread starter Thread starter Alain-79
  • Start date Start date
A

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
 
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
 
Back
Top