Printing Multiple Files from Excel

I’m new to this, so I’ll apologize in advance of the answer is overly simple or easily findable some where else…

I have an excel macro that loops data through a template and prints out each employees information. This works fine to to a physical printer. What I need to to have them print to a pdf using a name that I defined outside the print area.

Any suggestions?


maybe you can use the automatic saving +tokens, depending on where you’d like to extract the filename from. 
If there is no suitable token you can use the COM interface, which is described in more detail in the manual.

best regards,