Printing Excel to Preexisting Postscript File

[jrcabcd]

Hi,

I need to print an Excel sheet to a postscript file, and I'm using the PrintOut method to do this. But, I need to print the sheet to an already existing postscript file. Unfortunately, unlike Word's PrintOut method, Excel's PrintOut method does not have an append argument.

Anyone know of a workaround? Why doesn't Excel's PrintOut have an append argument?

Here's my line of code that does not work because append is not a valid argument:

Workbooks("testexcel.xls").Sheets("Sheet1").PrintOut printtofile:=True, _
prtofilename:="C:\temp\test.ps", append:= true

If you're curious, the reason I need to append to an already existing postscript file is that I'm creating a 2-page pdf report, where the 1st page is from a Word doc, and the 2nd page from an Excel doc. Thus, I need to write the Excel doc to a postscript file that I've already written the Word doc to.

Another alternative I thought of is to print both pages of the report to pdf, then merge them in PDFDistiller. But, I am not sure whether you can do this PDFDistiller call throught VBA. Anyone know if you can?

Thanks a lot,
Jonathan

<!-- / message -->