LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command Button - Macro to print to pdf, then send pdf to email. Tdahlman Excel Discussion (Misc queries) 2 May 1st 23 11:44 AM
Using Macro how to create email link for the email addresses in aRange or Selection Satish[_2_] Excel Worksheet Functions 8 December 28th 09 03:30 PM
How do I create an email macro to auto fill the email? Justin[_4_] Excel Discussion (Misc queries) 0 November 14th 07 10:49 PM
How do I print excel doc from an email kevinb Excel Discussion (Misc queries) 1 October 6th 05 05:43 PM
print macro and email KenL Excel Programming 4 February 18th 05 08:49 PM


All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"