My macro prints a spreadsheet to Acrobat Distiller. Is there a way I can incorporate my destination acrobat file name into my VBA code so that the procedure isn't interrupted by a prompt for the file name to be manually input

The same sheet is printed multiple times each with different acrobat file names

I am running excel 2000

Thanks, Kaval