Error when printing to Acrobat
 

The following simple macro (printing out a range called
POut) to a file Sample05.pdf shown here

Sub Macro1()
Application.ActivePrinter = "Acrobat PDFWriter on LPT1:"
Range("POut").PrintOut Copies:=1, _
ActivePrinter:="Acrobat PDFWriter on LPT1:", _
PrToFileName:="Sample05.pdf"
End Sub

gives me an Acrobat PDF Writer Error "Cannot print, file
is already in use or locked", and then a run-time
error '1004' telling me it couldn't be printed due to an
error on Acrobat PDFWriter. The same thing happened when I
tried printing to Distiller instead of PDFWriter. The
Sample05.pdf does not exist prior to running the macro and
I have no trouble sending it to the printer manually from
within Excel.

Thanks in advance.

Ray

Error when printing to Acrobat
 

Ray,

I'm no expert on printing to Acrobat, but
when I was recently searching the Microsoft KnowledgeBase for a problem I was
having in printing from Excel, did see many articles about problems of the sort
you're describing regarding the difficulties in printing to an Acrobat printer.

-- Dennis Eisen