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