Bullzip PDF + Multiple Excel Worksheets

[dslip]

I have a small issue.

When printing from an excel spreadsheet that has more than one worksheet, I do not get the second page 'printed' in the PDF document.

When printing I 'highlight' both worksheets by holding down the [CTRL] button and selecting both worksheets. If I go to print preview I can see multiple pages (1 portrait, 1 landscape)

When I print using Bullzip PDF only the first worksheet is printed (even though I can see Excel send Two(2) pages to the print spooler)

Can you help

[jr]

This problem can occur if you have different printing resolutions defined for the two worksheets.

Try changing the resolutions so that they match and print again.

Regards,
Jacob

[dslip]

Resolutions?

Can you please explain, Are you referring to page orientation (landscape vs portrait) or are you talking something else?

The two worksheets are not the same 'size' however when 'print preview' in Excel they both fit on a single page each (1 in landscape, 1 in portrait)

[Howard Kaikow]

[quote="jr"]This problem can occur if you have different printing resolutions defined for the two worksheets.

Try changing the resolutions so that they match and print again.

Regards,
Jacob[/quote]

The main cause consists of 2 factors:

1. Margin settings.
2. Portrait vs, Landscape

Other factors likely include "shrink to fit", etc.

[dslip]

So if I am clear on this

If one worksheet is portrait, and one sheet is landscape, then Bullzip PDF cannot print both sheets into one PDF document?

Bugga!

Bullzip is an excellent product and its a shame I now have to resume my search for a cost effective PDF printing solution.

[Howard Kaikow]

[quote="dslip"]So if I am clear on this

If one worksheet is portrait, and one sheet is landscape, then Bullzip PDF cannot print both sheets into one PDF document?

Bugga!

Bullzip is an excellent product and its a shame I now have to resume my search for a cost effective PDF printing solution.[/quote]

Not just BullZip.
All the PDF printing programs, that I have, do the same thing.

Could be that's the way Excel makes things available.

[bluestrattos]

what settings do i need to print in landscape ?

I tryed

Call objBullZip.SetValue("Rotation", "90")
Call objBullZip.SetValue("Orientation", "Landscape")
Call objBullZip.SetValue("Rotate", "yes")

no success

Thank you

[Howard Kaikow]

[quote="bluestrattos"]what settings do i need to print in landscape ?

I tryed

Call objBullZip.SetValue("Rotation", "90")
Call objBullZip.SetValue("Orientation", "Landscape")
Call objBullZip.SetValue("Rotate", "yes")

no success :(

Thank you[/quote]

In Excel, you need to change the values of the properties of the PageSetup oblect.

For example:
[code]
With wstStart.PageSetup
.Orientation = xlLandscape
.LeftMargin = HeaderFooterLeftRightMargin
.RightMargin = HeaderFooterLeftRightMargin
.TopMargin = BottomTopMargin
.BottomMargin = BottomTopMargin
.HeaderMargin = HeaderFooterLeftRightMargin
.FooterMargin = HeaderFooterLeftRightMargin
.LeftHeader = "&D(&T)"
.CenterHeader = "Worksheet: " & "&A"
.RightHeader = "Page &P of &N"
.LeftFooter = "Workbook: &Z&F"
.CenterFooter = ""
.RightFooter = ""
.PrintGridlines = True
' .FirstPageNumber = xlAutomatic
' .Order = xlDownThenOver
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = 1
End With
[/code]

[bluestrattos]

Understood! Thank you for your reply.

Another doubt, that maybe doesn't fit in the topic, but what if i want to print in landscape mode, outside Excel, using another application, or through coding an aplication ?

[Howard Kaikow]

[quote="bluestrattos"]Understood! Thank you for your reply.

Another doubt, that maybe doesn't fit in the topic, but what if i want to print in landscape mode, outside Excel, using another application, or through coding an aplication ?[/quote]

You would have to find out how to set the printer properties, either within the app, as I showed for Excel, or directly with the particular printer.