| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save as PDF not same size as Print and Print Preview in Excel | Excel Discussion (Misc queries) | |||
| Plot Area Automatically Expands in Print and Print Preview | Charts and Charting in Excel | |||
| excell won't print wants to save not print | New Users to Excel | |||
| Macro to Sort automatically when file/save is selected | Excel Discussion (Misc queries) | |||
| Create a print macro that would automatically select print area? | Excel Worksheet Functions | |||
Linear Mode
