Excel 2000 VBA Problems
I have some code that sucessfully prints out an entire workbook to a .PS file and then calls distiller on the said .PS file to produce a .PDF file. I use this way because in our enviornment, there are people with different versions of Acrobat and Distiller and this is the only cross-version way I could find.
Anyway, on one fellow's computer, Excel is producing a postscript file with an error that prevent's distiller (either his or mine) from creating the PDF file. If any of you could explain why this happens (and I realize I am on an Excel VBA board here), I would be very appreciative.
Failing that, if anyone has a code snippit that will allow me to save the entire workbook to a PDF file that works on both 5.0 and 6.0, please let me know!