Macro to convert file into PDF and then send via email

[MAGALY]

For the job I created a little macro. This macro starts each time you open the workbook and check the dates and sends an email based on the result. So far no worries. But I do not want to send Excel file as it is. The best thing would be to find the function that goes with the button sending a mail in the Excel toolbar, which is to send an image file. Solution is less appropriate to record such as PDF and then send it and then delete the pdf. FYI I work under Windows 2000 and Office 2000. Is there someone who can help me! How can you create a macro to convert a file into a PDF and then send it via email?

[opaper]

In 2007, I recorded a macro that gives this:

ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\myname\AppData\Local\Temp\File1.pdf", Quality:= _
xlQualityStandard, IncludeDocProperties:=False, IgnorePrintAreas:=False, _
OpenAfterPublish:=False
Application.Dialogs(xlDialogSendMail).Show

Does this help you in someway?

[Zecho]

Can you just specify the need to modify "myname & File1.pdf" characters as parameters, if you will forgive the intrusion?

but: \AppData\Local\Temp\ I have not understood? Why it should be located at this location?

[opaper]

I did not pursue the matter, I just saved the macro in Excel 2007 and I posted in case. If I have time (not too much the case now), I drown in xldialogsendmail to refine. Unless someone knows the answer.

[MAGALY]

Good evening and thank you. The problem for me is that the file will be opened at the same time as windows and everything should be automatic. For the person who uses the result of the macro must have nothing to do but to receive the mail which warns that there is a specific task to perform.

[Reegan]

Excel 2007 SP2 includes an addin to export to PDF which is not the case in previous versions. So you'll have to go through Acrobat Distiller (paid) or PDFCreator (free) or others (CutePDF, etc.) or services as pdfonline.com.