software

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: www.excelforum.com/member.php...foamp;userid=5833
View this thread: www.excelforum.com/showthread...hreadid=493331I 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 quot;Prompt for Filenamequot; rather than quot;Save in My
Documentsquot; as I had many files to create, and deselected the other
options. The drawback was that I had to click quot;savequot; for every file as
the macro ran its course.

Pete