http://tinyurl.com/cmt76

Many others have asked similar. You can peruse the results. I don't think
anyone asked for the entire combination, but all the parts should be there.

--
Regards,
Tom Ogilvy

"paulu" wrote in message
...
I am trying to automate the following manual steps which are carried out
manually after data is entered into the xl worksheet:
1 From the file menu choose Print
2 Select "Adobe PDF" as the printer name (a "Save PDF File as" window
opens)
3 Enter a file name that is a combination of two cells from the work
sheet
4 Display the pdf file
5 print a hard copy of the file
6 email a copy to a third party
7 return to the worksheet

Is this possible?
Is this the forum to be asking this?

cheers

--
paulu