| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use macro in Excel 2007 to convert to and email PDF file
When I assign a macro to convert & sent PDF file it seem to work when I
record the macro but when I run it it attached an xls file instead of a pdf file. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use macro in Excel 2007 to convert to and email PDF file
Excel version ?
And which PDF program do you use -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... When I assign a macro to convert & sent PDF file it seem to work when I record the macro but when I run it it attached an xls file instead of a pdf file. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use macro in Excel 2007 to convert to and email PDF f
Ron de Bruin,
Everything is actually accomplished in Excel 2007 - When recording the macro I go to the Ribon on Excel 2007 and select Send and then Email as PDF attachment it launches my email and attaches a PDF file of the spreadsheet I am in. However, when I actually run the macro it does everything right but it attaches the xls file instead of the PDF. "Ron de Bruin" wrote: Excel version ? And which PDF program do you use -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... When I assign a macro to convert & sent PDF file it seem to work when I record the macro but when I run it it attached an xls file instead of a pdf file. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use macro in Excel 2007 to convert to and email PDF f
See
http://www.rondebruin.nl/pdf.htm There is also a mail example on that apge -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... Ron de Bruin, Everything is actually accomplished in Excel 2007 - When recording the macro I go to the Ribon on Excel 2007 and select Send and then Email as PDF attachment it launches my email and attaches a PDF file of the spreadsheet I am in. However, when I actually run the macro it does everything right but it attaches the xls file instead of the PDF. "Ron de Bruin" wrote: Excel version ? And which PDF program do you use -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... When I assign a macro to convert & sent PDF file it seem to work when I record the macro but when I run it it attached an xls file instead of a pdf file. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use macro in Excel 2007 to convert to and email PDF f
I have no problem creating a PDF or email a PDF if I do it manually. The
problem is when I run a recorded macro to email a PDF it attaches an xls file and not a PDF. I can even record a macro to create a PDF file and save to my desktop that works just fine. "Ron de Bruin" wrote: See http://www.rondebruin.nl/pdf.htm There is also a mail example on that apge -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... Ron de Bruin, Everything is actually accomplished in Excel 2007 - When recording the macro I go to the Ribon on Excel 2007 and select Send and then Email as PDF attachment it launches my email and attaches a PDF file of the spreadsheet I am in. However, when I actually run the macro it does everything right but it attaches the xls file instead of the PDF. "Ron de Bruin" wrote: Excel version ? And which PDF program do you use -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... When I assign a macro to convert & sent PDF file it seem to work when I record the macro but when I run it it attached an xls file instead of a pdf file. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use macro in Excel 2007 to convert to and email PDF f
See the macro example that create the pdf and mail it on that page
Last macro on the page http://www.rondebruin.nl/pdf.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... I have no problem creating a PDF or email a PDF if I do it manually. The problem is when I run a recorded macro to email a PDF it attaches an xls file and not a PDF. I can even record a macro to create a PDF file and save to my desktop that works just fine. "Ron de Bruin" wrote: See http://www.rondebruin.nl/pdf.htm There is also a mail example on that apge -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... Ron de Bruin, Everything is actually accomplished in Excel 2007 - When recording the macro I go to the Ribon on Excel 2007 and select Send and then Email as PDF attachment it launches my email and attaches a PDF file of the spreadsheet I am in. However, when I actually run the macro it does everything right but it attaches the xls file instead of the PDF. "Ron de Bruin" wrote: Excel version ? And which PDF program do you use -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... When I assign a macro to convert & sent PDF file it seem to work when I record the macro but when I run it it attached an xls file instead of a pdf file. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use macro in Excel 2007 to convert to and email PDF f
That works GREAT! Thanks. One more question. How do I need to change the
code if I wanted to send the entire workbook and not just the active page? "Ron de Bruin" wrote: See the macro example that create the pdf and mail it on that page Last macro on the page http://www.rondebruin.nl/pdf.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... I have no problem creating a PDF or email a PDF if I do it manually. The problem is when I run a recorded macro to email a PDF it attaches an xls file and not a PDF. I can even record a macro to create a PDF file and save to my desktop that works just fine. "Ron de Bruin" wrote: See http://www.rondebruin.nl/pdf.htm There is also a mail example on that apge -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... Ron de Bruin, Everything is actually accomplished in Excel 2007 - When recording the macro I go to the Ribon on Excel 2007 and select Send and then Email as PDF attachment it launches my email and attaches a PDF file of the spreadsheet I am in. However, when I actually run the macro it does everything right but it attaches the xls file instead of the PDF. "Ron de Bruin" wrote: Excel version ? And which PDF program do you use -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... When I assign a macro to convert & sent PDF file it seem to work when I record the macro but when I run it it attached an xls file instead of a pdf file. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use macro in Excel 2007 to convert to and email PDF f
In the macros above the mail example you see how you can do that
Replace the ExportAsFixedFormat block in the mail macro with this ActiveWorkbook.ExportAsFixedFormat _ Type:=xlTypePDF, _ Filename:=FilenameStr, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ OpenAfterPublish:=False -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... That works GREAT! Thanks. One more question. How do I need to change the code if I wanted to send the entire workbook and not just the active page? "Ron de Bruin" wrote: See the macro example that create the pdf and mail it on that page Last macro on the page http://www.rondebruin.nl/pdf.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... I have no problem creating a PDF or email a PDF if I do it manually. The problem is when I run a recorded macro to email a PDF it attaches an xls file and not a PDF. I can even record a macro to create a PDF file and save to my desktop that works just fine. "Ron de Bruin" wrote: See http://www.rondebruin.nl/pdf.htm There is also a mail example on that apge -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... Ron de Bruin, Everything is actually accomplished in Excel 2007 - When recording the macro I go to the Ribon on Excel 2007 and select Send and then Email as PDF attachment it launches my email and attaches a PDF file of the spreadsheet I am in. However, when I actually run the macro it does everything right but it attaches the xls file instead of the PDF. "Ron de Bruin" wrote: Excel version ? And which PDF program do you use -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... When I assign a macro to convert & sent PDF file it seem to work when I record the macro but when I run it it attached an xls file instead of a pdf file. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use macro in Excel 2007 to convert to and email PDF f
I think I figured. I changed "activesheet" to "activeworkbook" and that
seems to work. Thanks again you have been very helpful. Rick "Ron de Bruin" wrote: See the macro example that create the pdf and mail it on that page Last macro on the page http://www.rondebruin.nl/pdf.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... I have no problem creating a PDF or email a PDF if I do it manually. The problem is when I run a recorded macro to email a PDF it attaches an xls file and not a PDF. I can even record a macro to create a PDF file and save to my desktop that works just fine. "Ron de Bruin" wrote: See http://www.rondebruin.nl/pdf.htm There is also a mail example on that apge -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... Ron de Bruin, Everything is actually accomplished in Excel 2007 - When recording the macro I go to the Ribon on Excel 2007 and select Send and then Email as PDF attachment it launches my email and attaches a PDF file of the spreadsheet I am in. However, when I actually run the macro it does everything right but it attaches the xls file instead of the PDF. "Ron de Bruin" wrote: Excel version ? And which PDF program do you use -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message ... When I assign a macro to convert & sent PDF file it seem to work when I record the macro but when I run it it attached an xls file instead of a pdf file. |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use macro in Excel 2007 to convert to and email PDF file
rick5555 wrote on 10/24/2008 14:26 ET :
That works GREAT! Thanks. One more question. How do I need to change the code if I wanted to send the entire workbook and not just the active page? "Ron de Bruin" wrote: See the macro example that create the pdf and mail it on that page Last macro on the page http://www.rondebruin.nl/pdf.htm Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message news: I have no problem creating a PDF or email a PDF if I do it manually. The problem is when I run a recorded macro to email a PDF it attaches an xls file and not a PDF. I can even record a macro to create a PDF file and save to my desktop that works just fine. "Ron de Bruin" wrote: See http://www.rondebruin.nl/pdf.htm There is also a mail example on that apge Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message news: Ron de Bruin, Everything is actually accomplished in Excel 2007 - When recording the macro I go to the Ribon on Excel 2007 and select Send and then Email as PDF attachment it launches my email and attaches a PDF file of the spreadsheet I am in. However, when I actually run the macro it does everything right but it attaches the xls file instead of the PDF. "Ron de Bruin" wrote: Excel version ? And which PDF program do you use Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick5555" wrote in message news: When I assign a macro to convert & sent PDF file it seem to work when I record the macro but when I run it it attached an xls file instead of a pdf file. I am trying to create a macro to convert a excel file to PDF. Can you please assist |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert email address file in Excel 2000 to Word file with commas | Excel Discussion (Misc queries) | |||
| Macro to split excel file into seperate files and then email | Excel Discussion (Misc queries) | |||
| How do you send an excel file as a link in an email in excel 2007 | Excel Discussion (Misc queries) | |||
| How do I convert an email download from an Excel spreadsheet file | Excel Discussion (Misc queries) | |||
| How do I convert an email download from an Excel spreadsheet file | Excel Discussion (Misc queries) | |||
Linear Mode
