Hi All,

I been put into a new role which is really repetitive. I have a template quote spreadsheet which I must fill out to each and every query. The quote sheet is converted to pdf by Cutepdf by print to file.

I really need (want) to automate this by having a macro that:
1. Prints Cutepdf to file as per normal
2. Makes the file name: "Option " <Cell: D:5>

So if cell D5 had 12345, when I used Cutepdf to print to file it would already have "Option 12345". I would only need to direct where the file would be saved.

I have looked for my needs on the forum but unable to find. This would change my mundane life if someone could assist. Oh and I am using 2010 Excel.

Regards,

Ken