Save excel worksheet as PDF

Hi,

I've very little VBA experience but I need to create some code that will save an excel worksheet into PDF. I have downloaded PDF creator but am unsure where to start with the code.
The filename needs to contain specific information generated from cell E7 and the date the file was created it must also save into a folder which is the same name as cell E7.
The worksheet that I am generating the document from is called 'Report'.

Any help is greatly appreciated.

N.B
I don't have to use PDF creator, it just needs to be a free PDF creation program.

Thanks shg,

I've tried using the excel guru's code, but I get the error message compile error - Duplicate option statement.

Any idea's how I fix this ?