| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cant Send Email Attachment | Excel Discussion (Misc queries) | |||
| Help to Send as attachment. | New Users to Excel | |||
| Send as Attachment | Excel Discussion (Misc queries) | |||
| My send to in excel/word does not offer send as attachment | Excel Discussion (Misc queries) | |||
| send as attachment | Excel Discussion (Misc queries) | |||
Hybrid Mode
