Mass Create PDF Loop

[CHolden]

Hi Everyone,

Here is what I am hoping to accomplish. Currently I have a print macro within VBA that will formulate names from a named range “listAthlete” in a listbox and allow me to print a sheet for each athlete chosen. I would like to have the same or similar set up, but instead of printing the sheet, I would like excel to create a PDF version named after the person(s), and save the copies in a folder. Any help would be greatly appreciated! Attached is a excel copy with some dummy data.

[Keebellah]

All you need to do is export the worksheet as pdf

Please Login or Register  to view this content.

Just create the worksheet the way you want it and set it up as you would want it printed.
Then incode the code.

The syntax is if you want to expoer the active sheet

Save2PDF whichSheet:=ActiveSheet

Happy coding

[CHolden]

Hi Keebellah,

I'm sorry my excel knowledge is pretty remedial. What do you mean by syntax? Here is what I tried with the information you gave me: I created another command button within the FrmPrintWizard Form, then copy pasted the code you suggest. I had no success there. I also tried going into module1 and copy pasting the information you had. I also had no luck there. I am sure I'm missing the boat somewhere.

[Keebellah]

You see, if you attach a file with macros and say that you have a print macro that does this and that, you give the reader (us in this case) the idea that you know something about what you're doing.
Don't do that, just say I copied a macro and blah blah and also mention that your knowledge of VBA is not up-to-date, it's okay to say that we all started from zero, the only way to learn is byt trial-and-error and a lot's of time
I'll pick it up and see if I can implement it for you

[Keebellah]

Okay, this my idea, I added an option button to the print form, default it is true (activated) when you print, I also added the question if you want to print , that is something you should always do, it is waht you call 'USER FRIENDLY'

I've attached the file and it works, one output included

Hope this helps

[CHolden]

Keebellah,

I opened your version and tried it out. I like the option button, but I can't get it to toggle of. It always seems to stay selected on. Also when I then run the names to PDF save, I only get one copy saved for the last athlete chosen instead of all of the desired ones. Lastly, how can I change the name of the PDF file to be the same of the athlete(s)? I apologize for all of the questions, but I do appreciate all of your help.

[Keebellah]

Sorry my mistake, should be a checkbox, changed it

[Keebellah]

I overlooked your last one about the file names, will do it in a moment

[Keebellah]

Modified it not tested on all but should do it.

[CHolden]

Great! Everything seems to work. Thank you very much for taking time to help me out.

[Keebellah]

Glad it worked
VBA is really quite simple, just take the time