Auto Produce PDF

[Rikuk]

Good Afternoon,
I currently produce a monthly scorecard from a standadised worksheet and create a pdf using adobe acrobat 8. The suppliers are selectable from a validation list is it possible to automate this saving me selcted each supplier & saving a hard copy of the pdf?

Rik

[Andy Pope]

Have you tried doing the process with the macro recorder on?

The problem part will be naming the pdf file but I'm sure there are examples of that on the forum.