Results 1 to 6 of 6

Thread: Printing on continuous document pages with Excel

  1. #1
    Join Date
    Apr 2008
    Posts
    53

    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

  2. #2
    Join Date
    Oct 2008
    Posts
    117

    Re: Printing on continuous document pages with Excel

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

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

  3. #3
    Join Date
    Nov 2008
    Posts
    211

    Re: Printing on continuous document pages with Excel

    • 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

  4. #4
    Join Date
    Nov 2008
    Posts
    161

    Re: Printing on continuous document pages with Excel

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

  5. #5
    Join Date
    Sep 2005
    Posts
    1,306

    Re: Printing on continuous document pages with Excel

    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.

  6. #6
    Join Date
    May 2008
    Posts
    4,570

    Re: Printing on continuous document pages with Excel

    You need code like this:

    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.

Similar Threads

  1. Replies: 2
    Last Post: 01-02-2012, 02:07 PM
  2. printing multiple pages on excel over network
    By Jasthi in forum Windows Software
    Replies: 6
    Last Post: 09-07-2011, 09:50 PM
  3. No pages selected error in PDF Document
    By Fragman in forum Windows Software
    Replies: 4
    Last Post: 23-02-2010, 04:23 PM
  4. How to fix number of pages in word document?
    By Jmackenz in forum Tips & Tweaks
    Replies: 3
    Last Post: 16-09-2009, 08:22 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,717,152.64422 seconds with 16 queries