Macro to automatically print & save as PDF

P

PaulaK

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.
 
Top