I'm trying to print selected Excel sheets to Acrobat
Distiller, with an instruction of where to save it.

This line creates a pdf file in the right place, but it
can't be opened by Acrobat.

ActiveWindow.SelectedSheets.PrintOut Copies:=1,
ActivePrinter:="Acrobat Distiller on Ne08:",
PrToFileName:="c:\myFiles\test.pdf"

This line creates a pdf file that is perfect, but I have
press the save button on the dialog box myself.

ActiveWindow.SelectedSheets.PrintOut Copies:=1,
ActivePrinter:="Acrobat Distiller on Ne08:",

Can someone tell me how to make the first command work so
that I can print 90 files without having to hit Save 90
times? (I know I've asked this before, but was not able
to implement the answer satisfactorily).

Thanks
Daniel