Ron,

It is a privilege to get a chance to test your code...

I tested all the functions at least once and they all worked fine.

Environment:
Windows XP Media Centre
Excel 2007

Suggestions:

1. Create_PDF_With_Sheets_With_specific_Word()
It would be better if the message "No sheets with the word RDB_PDF in it" is
shown before asking for a pdf file name...

2. It will be good if user is allowed to specify the name as an existing
document.

Regards,
Sheeloo


"Ron de Bruin" wrote:

Hi all

Today I create a new draft webpage for creating and mailing PDF files
with the Microsoft PDF add-in in Excel 2007.
For the mail part you must also use Outlook 2007.

If you use Excel 2007 and have the MS PDF add-in installed or want to do that and have a
few minutes to test it you make me very happy <g

This is the draft page
http://www.rondebruin.nl/pdf2.htm
My mail address is on top of the page or reply in this thread
Good or bad feedback is welcome

If it is ready I want to replace my original PDF page with it, this is the page now
http://www.rondebruin.nl/pdf.htm


Thank you very much



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm