Export pdfs automatically from data validation list

Short answer, yes, you can do this with VBA.

Long answer, yes, but you'll need to provide a lot more information and, ideally, a sample workbook.

Thanks for your quick reply!

I have attached a sample workbook. Cell B1 holds the data validation list with each customer number - the list that the data is based on lies in sheet "Customers".
For each customer number in the list, I'd like to export a pdf with the file name in cell G1, saved in a certain location.

Did I provide enough information or did I miss something?

OK, try this as a starter ...

Please Login or Register  to view this content.

You're welcome.

... how should i write the path name? sPath = "C:\blah\blah" ?

Yes.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

You're welcome. Thanks for the rep.


And thanks for the kind wishes ... looks like it will be an "interesting" summer

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread