cycle through data validation list to print pdf with a file name

[Carla carla]

Hello, at the moment I have a an excel report for 500 kids. The execl report is then populated to the pdf.
I have created a data validation list using the ID to string name, marks and other details.
When I print to pdf the file name appears to be the student ID.
Is there a way for me to set a file name for each file example the student name instead of ID?

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

 

[John_w]

This question has already been asked in original thread -

VBA to cycle through drop down list and save as pdf with file name

Hello, I need help on saving my drop down list to individual pdf file with file name.

www.mrexcel.com

 

[Carla carla]

This question has already been asked in original thread -

VBA to cycle through drop down list and save as pdf with file name

Hello, I need help on saving my drop down list to individual pdf file with file name.

www.mrexcel.com

Yes, but I need the filename to be the name not the ID as it is so diffcult.

 

[Carla carla]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

-sensitized if necessary).I

 

[Carla carla]

So this is my file, the ID is the data validation list and it cycle through all the data for each report. I want the file name to be the name instead of the ID,is that possible?

 

[mumps]

It is hard to work with a picture. Please follow the instructions in Post #2.

 

[Carla carla]

It is hard to work with a picture. Please follow the instructions in Post #2.

I am trying but it doesnt work for me can I send it via email?

 

[mumps]

Try Dropbox.com or Box.com

 

[Carla carla]

Try Dropbox.com or Box.com

sample 2 (3).xlsb

Shared with Dropbox

www.dropbox.com

Here is my file, thank you.