Robert,
If you have Adobe Acrobat or some 3rd party pdf drivers, then:
Application.ActivePrinter = "Adobe PDF on Ne01:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Adobe PDF on Ne01:", Collate:=True

(Note: Use record macro to see what default pdf driver is chosen).

"Robert Dieckmann" wrote:

Is it possible to print a pdf file through vba? If so, how? I would prefer
to do this rather than import into my spreadsheet to keep the size down. I
use Excel 2000.

Robert