Error printing from VBA to Adobe PDF printer, "Do not send fonts to Distiller"?

N

Nate

Hi,

I'm printing from VBA to an Adobe PDF printer; the first time I open
the file and run the macro, it works, but subsequent times I get an
error message:

When you create a PostScript file you have to send the host fonts.
Please go to the printer properties, "Adobe PDF Settings" page
and turn OFF the option "Do not send fonts to Distiller".

Of course, the option IS turned off, so I don't think it's anything to
do with the fonts.
(I've also patched Acrobat to the latest version.)

I can successfully print to other PostScript printers with no problem,
but I'd really like to use the Adobe PDF printer, as (a) when it's
"distilled", it creates much smaller PDF file sizes, and (b) we've paid
out hundreds of pounds for Acrobat 7(!)

Has anyone got any suggestions?

Regards,

Nate

PS Tested this on Excel 2000 / Windows 2000 and Excel 2003 / Windows
Server 2003, exact same problem.
 
N

Nate

It is with great pleasure that I can say we found the problem! We
narrowed it down to one worksheet in the workbook, then removed
elements (values, formulas, charts, formats, etc.) one by one... until
we were left with a strange thick line between cells (that had been
hidden by a chart) that wasn't a cell border, or any other identifiable
Excel structure. It was this line, whatever it was, that was causing
the Adobe PostScript printer to fail - though no other PostScript
printer seemed to have a problem with it. Anyway, we rebuilt the
worksheet, and it works fine!

Hope this helps someone in the future.



Nate
 
G

Guest

How did you removed that strange line? I have a similar problen and don't
know what to do about the line AND distiller.

Thanks!
 
N

Nate

user said:
How did you removed that strange line? I have a similar problen and don't
know what to do about the line AND distiller.
Click to expand...

We deleted the whole sheet and started from scratch. In fact, further
investigation reveals the the weird line might only be a symptom of the
underlying problem, and not the cause.

Nate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

howto send host fonts to adobe pdf printer 3
Print to PDF using Adobe Acrobat 6.0 2
issues with getting .pdfs to be created 3
Issue with ExportAsFixedFormat PDF (and solution) 2
Disable Adobe save file prompt 1
Automated Printing 2
Automated Print from Excel to PDF 2
Bypass "Save PDF File As" Prompt via VBA in Excel 0

Top