Macro to automatically print & save as PDF
 

I need some help to write a macro that will automatically print a worksheet &
then save it as a PDF document to a specific location on the server.

The work book has 3 sheets:-
Sheet 1 - Data entry sheet that updates fields in sheet 2 & 3
Sheet 2 - Invoice that needs to be printed & saved as a PDF
Sheet 3 - Delivery Note that needs to be printed & saved as a PDF

The workbook has been created in Excel 2007, but needs to be compatible with
2003.
--
PaulaK

Macro to automatically print & save as PDF
 

Hi PaulaK

Start here
http://www.rondebruin.nl/pdf.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"PaulaK" wrote in message ...
I need some help to write a macro that will automatically print a worksheet &
then save it as a PDF document to a specific location on the server.

The work book has 3 sheets:-
Sheet 1 - Data entry sheet that updates fields in sheet 2 & 3
Sheet 2 - Invoice that needs to be printed & saved as a PDF
Sheet 3 - Delivery Note that needs to be printed & saved as a PDF

The workbook has been created in Excel 2007, but needs to be compatible with
2003.
--
PaulaK