I would like to print to a pdf file from xl. When I hit
print it asks for a name to save the pdf file to. I have
about 100 pages that I will be doing this for, I don't
want to have to type in each page name.

how do I, using vba, tell xl what to name the file.

Thanks
steve