Student7
03-26-2009, 09:13 AM
Multiple sheets in a workbook need to be converted to single .tif file using virtual printer "Universal Document Converter".
Problem is that when using the .printout function, multiple print jobs are sent, creating a seperate .tif files for each job.
I've seen example code to do exactly what I want, but the conversion is to a .pdf, and all these solutions rely PDFCreator or Distiller objects that of course are not available on the Universal Document Converter.
My best idea on this is to copy the ranges I want to print to a single temporary sheet, set page breaks, print the single sheet, then delete it. I want to avoid this if possible, as the end result will look bad due to the sheet layout
Any suggestions?
Problem is that when using the .printout function, multiple print jobs are sent, creating a seperate .tif files for each job.
I've seen example code to do exactly what I want, but the conversion is to a .pdf, and all these solutions rely PDFCreator or Distiller objects that of course are not available on the Universal Document Converter.
My best idea on this is to copy the ranges I want to print to a single temporary sheet, set page breaks, print the single sheet, then delete it. I want to avoid this if possible, as the end result will look bad due to the sheet layout
Any suggestions?