Macro to PDF a sheet in workbook and email (outlook) to an email address in a cell

See this thread as an example:

http://www.excelforum.com/excel-gene...k-1-macro.html


Regards, TMS

If you had excel 2007 or newer this could be easily accomplished as the newer versions have a built in PDF creator.
Your "MS-OFF VER", shows that you have XL2003.
XL'03 does not have a built in PDF creator and you would probably have to do something different.

My experience has shown that with older versions, when you selected a PDF printer, the PDF printer will default to save as the Workbook name.
You could create a macro that copies the sheet, when you have that sheet copied, then save it and then PDF it.
If you start the macro recorder, then right click on the sheet tab and select Move or Copy>to new workbook.
The sheet will then be in a new workbook. Save the workbook and then PDF it.
There are codes available that will let you save a workbook according to cell value, but this cannot be done with the macro recorder.
Follow the steps with the macro recorder, then show us the code, somebody will be able to supply revised code so that the workbook will be saved as a cell value.

@tt3: I don't think you're helping by posting code that you don't understand and have corrupted from the original.


Regards, tms

@Dave: good call. I hadn't even noticed the profile. Just seems a lot of people wanting PDF files and hence I just offered a link to a similar thread I answered very recently.

I use the Bullzip PDF printer as the default printer on my laptop so I don't end up trying to print stuff to a non-existent printer, especially if/when I'm testing.

It looks as though you can amend a settings file to determine the filename without it asking. I haven't tried this (yet) but it might be worth a look.

Cheers, TMS

You're welcome. Does that mean you're not using Excel 2003?

Regards, TMS