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.