View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zorro[_3_] Zorro[_3_] is offline
external usenet poster
 
Posts: 5
Default Macro to print and email a pdf

Hi all,
I've got a PDF printer installed (PDF Creator), and I would like to make a
macro to do the following things:
- print the sheet in PDF in a temporary file, without ask the user for a
filename,
- send an email with this PDF,
- delete the PDF.

I know how to print, but I don't know if it's possible to impose a filename
for the PDF (I don't want the user to be asked for a filename).

Thank you for your answers.

Zlika