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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top