I did this with Adobe Acrobat v7 - you select the Adobe Printer and
Print the Excel file. You should set the options in the Adobe Printer
Driver first - I chose "Prompt for Filename" rather than "Save in My
Documents" as I had many files to create, and deselected the other
options. The drawback was that I had to click "save" for every file as
the macro ran its course.

Pete