Creating a PDF in Excel Automatically

[Brittany]

I have a function within MS Access that automatically creates an Excel spreadsheet. Then I have it automatically create a PDF with the following code:

SendKeys pdf_file_name & "{Enter}", False
xlWrkbk.PrintOut Copies:=1, ActivePrinter:="Acrobat Distiller on Ne00:", Collate:=True

The "SendKeys" appears to cause some problems. Does anyone know of another way to create a PDF without using "SendKeys"?

 

[Juan Pablo González]

I seem to remember that you can configure Distiller so it won't prompt you for a filename ? and it will put the printed file in the \Output\ folder of the Acrobat folder... That way you wouldn't have to use Sendkeys to send the filename...