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 -->
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 -->