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

Thanks
Matthew


--
Matthew McManus
------------------------------------------------------------------------
Matthew McManus's Profile: http://www.excelforum.com/member.php...fo&userid=5833
View this thread: http://www.excelforum.com/showthread...hreadid=493331

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