Creating PDF file from Excel

Hi

I am running Excel (Office 2007) with the posibility to Export to PDF

I am trying to create a macro/button that:

Saves a workbook as a PDF file
- With a name that I built from the workbook
- in a folder I build from the workbook

If the folder exist OK
if the folder does not exist - ask to create it
If the file already exist in the folder - ask to overwrite or not
If the file does not exist - create it and tell

- publich the pdf



I have tried several things with the export function but I have troubles with the error controls and things going on unatended

Anybody have a good idea

/lars