I have Excel 2003 and Acrobat Professional 6. I'm trying to automate saving the current worksheet to a distincly-named PDF file.

The Automate tab allows you to create and run Office Scripts, which allow users to automate tasks in Excel.

How to use PDF Data Connector in Microsoft Excel In order to be able to use Excel’s PDF importer feature, you must first connect a PDF document to the Excel spreadsheet you are working on.