|
Send As PDF Attachment
Hi
I would like to send a single page from a work book that multiple sheets as a PDF. Is this possible? At the moment when i attempt to send by PDF it sends the entire work book. As i said i would just like to send one page from a sheet. Is this possible? Thanks guys. Adam |
Send As PDF Attachment
Excel 2007 ?
Try my add-in http://www.rondebruin.nl/mail/add-in.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "SnackBar" wrote in message ... Hi I would like to send a single page from a work book that multiple sheets as a PDF. Is this possible? At the moment when i attempt to send by PDF it sends the entire work book. As i said i would just like to send one page from a sheet. Is this possible? Thanks guys. Adam |
Send As PDF Attachment
Yes Excel 2007
"Ron de Bruin" wrote: Excel 2007 ? Try my add-in http://www.rondebruin.nl/mail/add-in.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "SnackBar" wrote in message ... Hi I would like to send a single page from a work book that multiple sheets as a PDF. Is this possible? At the moment when i attempt to send by PDF it sends the entire work book. As i said i would just like to send one page from a sheet. Is this possible? Thanks guys. Adam |
Send As PDF Attachment
You can use the add-in or use this code example
http://www.rondebruin.nl/pdf.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "SnackBar" wrote in message ... Yes Excel 2007 "Ron de Bruin" wrote: Excel 2007 ? Try my add-in http://www.rondebruin.nl/mail/add-in.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "SnackBar" wrote in message ... Hi I would like to send a single page from a work book that multiple sheets as a PDF. Is this possible? At the moment when i attempt to send by PDF it sends the entire work book. As i said i would just like to send one page from a sheet. Is this possible? Thanks guys. Adam |
Send As PDF Attachment
Should i use the code in a Macro? So it literaly just sends the active sheet?
Could i tweak the code to just send the first page of the sheet? Never really dont anything as complex as that before but it looks good. Thank you for the help. "Ron de Bruin" wrote: You can use the add-in or use this code example http://www.rondebruin.nl/pdf.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "SnackBar" wrote in message ... Yes Excel 2007 "Ron de Bruin" wrote: Excel 2007 ? Try my add-in http://www.rondebruin.nl/mail/add-in.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "SnackBar" wrote in message ... Hi I would like to send a single page from a work book that multiple sheets as a PDF. Is this possible? At the moment when i attempt to send by PDF it sends the entire work book. As i said i would just like to send one page from a sheet. Is this possible? Thanks guys. Adam |
Send As PDF Attachment
Hi Ron
Code is fantastic! Thank you again. In your notes it says it is easy to change it to send a range, how would i go about doing this? Kind Regards Adam "Ron de Bruin" wrote: You can use the add-in or use this code example http://www.rondebruin.nl/pdf.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "SnackBar" wrote in message ... Yes Excel 2007 "Ron de Bruin" wrote: Excel 2007 ? Try my add-in http://www.rondebruin.nl/mail/add-in.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "SnackBar" wrote in message ... Hi I would like to send a single page from a work book that multiple sheets as a PDF. Is this possible? At the moment when i attempt to send by PDF it sends the entire work book. As i said i would just like to send one page from a sheet. Is this possible? Thanks guys. Adam |
Send As PDF Attachment
Hi Adam
If you want to send the first page Change ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _ Filename:=FilenameStr, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ OpenAfterPublish:=False To ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _ Filename:=FilenameStr, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ From:=1, _ To:=1, _ OpenAfterPublish:=False See also the other examples in the macros above the mail macro -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "SnackBar" wrote in message ... Hi Ron Code is fantastic! Thank you again. In your notes it says it is easy to change it to send a range, how would i go about doing this? Kind Regards Adam "Ron de Bruin" wrote: You can use the add-in or use this code example http://www.rondebruin.nl/pdf.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "SnackBar" wrote in message ... Yes Excel 2007 "Ron de Bruin" wrote: Excel 2007 ? Try my add-in http://www.rondebruin.nl/mail/add-in.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "SnackBar" wrote in message ... Hi I would like to send a single page from a work book that multiple sheets as a PDF. Is this possible? At the moment when i attempt to send by PDF it sends the entire work book. As i said i would just like to send one page from a sheet. Is this possible? Thanks guys. Adam |
| All times are GMT +1. The time now is 01:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com