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

  • Thread starter Thread starter Nate
  • Start date Start date
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.
 
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
 
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!
 
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
 
Back
Top