See
http://www.rondebruin.nl/pdf.htm
There is a link to Ken's site if you not use 2007
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Tommy-B" wrote in message ...
What I need to do is automate a workbook via a command button that when the
cells are filled with the data needed you can click the button and it will
PDF the file and then email it to the desired receipt. Any VBA code would be
greatly appreciated. I notice that MS Word has this function built in but
Excel doesnt?
Help Please!!!!