Export as PDF every iteration of worksheet based on data validation list

[kewellh]

Hi I have a worksheet I want to export to PDF that changes based on data validation of a list of say 100 different customer numbers.

I want 1 file per customer number to export to PDF automatically - I don't want to have to rename in the Save As box each time.

Here is some code but I get error at the next.

Any ideas?

Please Login or Register  to view this content.

'or, if you see where it record the file name, you can use the
'xName variable to populate the name...how to do this?

[Keebellah]

Reade the attached file (also on the forum) and use CODE tags
http://www.excelforum.com/misc.php?do=bbcode#code