Hello, I hope someone can help me with this please.

I researched the history of postings on this subject, and
I got close to resolution, but I never located a solution.

I am using VBA in Excel with Windows 2000; Acrobat 5
(maybe upgrading to 6.0 in a few months, but I need a
solution now for version 5.0);

I have over a hundred excel files that need to be
separately converted to PDF. My code so far looks like the
following:

Sheets("Sheet1").Select
ActivePrinter = "Acrobat Distiller on Ne01:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1

Two problems are encountered:

1) I have to press enter on every loop (100+): how can
this be fixed in code?

2) How do I send the output to a specific path?

Your example code would be most appreciated. Thanks in
advance.