I am trying to print Excel to Adobe 6 using VB. The code is supposed to print to file with this line:
ActiveSheet.PrintOut , printtofile:=True
This line does not run but gets a message from adobe PDF:
"When you create a Postscript file you have to send the host fonts. Please go to printer properties, "Adobe PDF settings" page and turn OFF the option "do not send fonts to Distiller""
BUT - despite this message Adobe 6 doesn’t have "do not send fonts to Distiller". It does have " do not send fonts to Adobe PDF". I have turned this off ... But it makes no difference.
Can someone explain how I can get print-to-file in Adobe 6 from VB
Thank you for your help
Stephen Kinsella
Programatically creating PDF by printing to the Adobe PDF printer requires this two step approach because you otherwise don't have any control over the output filename. You first write out a PostScript file with a filename that you specify in your program, then you start Distiller - using the Distiller API from the Acrobat SDK - to convert this Postscript file to PDF. As the last step, you delete the PostScript file.
Try to rename the file you've generated to a .ps extension and then double-click on it. Does Distiller start and create a PDF file?