pdf files

[Matthew McManus]

Is it possible to make and save an excel file as a pdf file using macro code?

Thanks
Matthew

[Pete]

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