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