Problem with PDF creation

[MarkI]

Hello all

I have a piece of code which has been successfully creates a PDF of the
active sheets in my workbook to a location specified. That's using Acrobat 4
with Excel 2003

However the clients in my organisation have been upgraded to Acrobat 7 and
whilst the code seems to work and a PDF file is still created, it is always
damaged and cannot be opened.

Has anyone come across this before?

This is a snippet of code that does the PDF conversion:

ActiveWorkbook.PrintOut copies:=1, preview:=False, ActivePrinter:="Adobe
PDF", printtofile:=True, collate:=True, prtofilename:=pdfilename

Many thanks

 

[Dustin K. Osburn]

I'm far from an expert, but I've noticed that when you open PDF
documents created in newer versions of Acrobat in an older version of
Reader, you'll get an error warning that some content may not display
as intended. Perhaps the reverse is true to some other extent?

Regardless, Acrobat 4 is ancient history as far as software is
concerned, I'd highly suggest upgrading before you go looking to
change code that worked perfectly well before.

Cheers,
- Dustin

 

[David McRitchie]

Who can't read it. If it is the people with Adobe Reader
does it work with Adobe Reader 8, AND does the old
stuff work with 8 also. Not sure but I think there were
some problems with those who access PDF files within
a browser (addon) rather than directly opening the file
with the reader.

http://www.adobe.com/cfusion/knowledgebase/index.cfm?event=search&product=&search_text=firefox 8

 

[MarkI]

Hello all

I have a piece of code which has been successfully creates a PDF of the
active sheets in my workbook to a location specified. That's using Acrobat
4 with Excel 2003

However the clients in my organisation have been upgraded to Acrobat 7 and
whilst the code seems to work and a PDF file is still created, it is
always damaged and cannot be opened.

Has anyone come across this before?

This is a snippet of code that does the PDF conversion:

ActiveWorkbook.PrintOut copies:=1, preview:=False, ActivePrinter:="Adobe
PDF", printtofile:=True, collate:=True, prtofilename:=pdfilename

Many thanks

Thanks for the pointers. Apparently by printtofile being true, I'm creating
a postscript file...but I've also been led to believe I have to use the
distiller API????

I'll keep plodding on...