Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Excel using Acrobat Adobe | Excel Discussion (Misc queries) | |||
How do I auto-save multipage report printing to Acrobat Distiller | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Printing using Acrobat | Excel Programming | |||
After using Acrobat Distiller object, certain formatting causes error | Excel Programming |