I have a report in Excel where a selected number of worksheets are sent using VBA to PDF Creator via the PDF Queue, Combined and then Printed. Selected sheets are printed in "Chapter" batches, page numbered accordingly with uniqie Chapter pefix and consecutive Page numbers depending on pages in the worksheet.
All works perfectly until I get to the worksheet which has a large number of rectangle shapes (used as drawing dimension tables), lines (used as drawing dimension lines) and many border formatted cells to create the drawing. PDFCreator arrives at this drawing and then prints a blank sheet. If I print this sheet directly through the print menu to PDFCreator it works fine. I cannot get PDF Creator to include any content of the graphic worksheet through the PDFCreator vba commands.
I have tried a "Sleep 5000" entry in the PDF queue assuming it may have been needing longer to "think about it", but this has not worked. There are nil imported graphics on this worksheet.
Printed separately through PDF the single page file is 2mb in size, when you click on this worksheet it takes a second or two to "refresh" the screen content, so it is quite a busy worksheet.
I hope you can assist on this conundrum.