Save worksheet as PDF then email

Hi,

I have a worksheet which represents an invoice. I wish to save the invoice as a PDF file and then email to a specified address depending on who the invoice is for (the email address should be retrieved from the worksheet).

I am having trouble with setting the file name and path of the PDF. The type of format I am after is:

2011-12 Invoice - (then the name of the individual the invoice is being sent to - in this case taken from a cell within the worksheet) - (then the current date).PDF

When I run the code i currently have (which does not deal with the emailing of the invoice currently and any help on that would be greatly appreciated - I have code for this but dont want to make the thread too long) it returns the error as follows:

Run-time error '424':
Object required

and highlights the file name that I have defined.

The code i have can be shown below:

Please Login or Register  to view this content.

Any assistance with this matter is greatly appreciated. Please accept my apologies if I have not followed the forum rules appropriately this is my first post.

Thanks very much in advance

Why not use Excels' built in functions to create the PDF ?

Please Login or Register  to view this content.

See this by ron de Bruin

as an option...

Please Login or Register  to view this content.

Dear all,

Thanks again for the quick responses however i am still having trouble with this code.

I have adapted what was given in the responses as follows but it returns the following error:

Run-time error '91'
Object variable or With block variable not set

Please Login or Register  to view this content.

Any help with troubleshooting this error is greatly appreciated.

Thanks

Pjxcelwizard,

Sometimes when a simple problem requires a complicated solution its better to approach it from a different direction. Why not install a free pdf printer that can easily convert your worksheet to pdf? Check out this article on choosing the best pdf printer and installing it on your computer: http://www.talesofinterest.net/choosing-the-best-free-pdf-printer-and-installing-it/

Change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.