ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro to print and email a pdf (https://www.excelbanter.com/excel-programming/360740-macro-print-email-pdf.html)

Zorro[_3_]

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




All times are GMT +1. The time now is 05:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com