Printing on continuous document pages with Excel

Hello,

I have a problem to define a paper size and print area in Excel (2003) for the continuous paper (bundles).

I have a dot matrix printer (needle) Oki ML 5521 designed to print on continuous carbon less paper. Only now, the printer driver is basic and does not set the printer to my paper. And impossible to determine the format in my excel.

Format of my paper: screen (banner) consists of three identical sheets side by side. Size of screen: 6 inches (15.24 cm) in height, 30 cm wide (10cm x 3 sheets). I would like to print in a specific area of the three sheets of the screen (the same way, I'll do it for a sign "="), And then it goes to next screen.

Have you a solution?
Thank you for your help

We must define the property PageSettings.Landscape was true for print in landscape mode.

If you use the PrintDocument class: printDocument.DefaultPageSettings.Landscape = true;

• Select a range of cells.
• Press the Ctrl key and select another, hold down the Ctrl key to select more beaches.
• Select Page Layout -> Print Area (in Page Setup Group) -> Set Print Area. Each line in the print area is printed on a separate page

First try selecting all sheets that you want to print and then start printing as, first click on the first tab and ctrl-click on subsequent tabs. Remember to separate the sheets when you're done. Almost everything you do to one sheet will be done for others in this group. If you want to print all the sheets, you can show the print dialog: File|Print (in xl2003 menus) Select Entire Workbook in the Print What section -- don't use active sheet(s).

To combine non-continuous ranges into a single range:

• First Select and then copy different ranges.
• Go to Home -> Click Dialog Box Launcher in the bottom-right corner of Clipboard Group.
• And click Paste All command and paste all copied ranges into one single range.

You need code like this:

Quote:

---

With ActiveDocument.Sections(1).Headers(1).PageNumbers
.RestartNumberingAtSection = True
.StartingNumber = 16
End With

---

This code assumes that the numbering is in the primary header of the first section of the document.