Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 02-02-2010
Member
 
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
Reply With Quote
  #2  
Old 02-02-2010
Member
 
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;
Reply With Quote
  #3  
Old 02-02-2010
Member
 
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
Reply With Quote
  #4  
Old 02-02-2010
Member
 
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).
Reply With Quote
  #5  
Old 02-02-2010
Member
 
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.
Reply With Quote
  #6  
Old 02-02-2010
Member
 
Join Date: May 2008
Posts: 4,565
Re: Printing on continuous document pages with Excel

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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Printing on continuous document pages with Excel"
Thread Thread Starter Forum Replies Last Post
How to increase the document size while printing from Microsoft Excel Sreedharna MS Office Support 2 01-02-2012 02:07 PM
printing multiple pages on excel over network Jasthi Windows Software 6 09-07-2011 09:50 PM
No pages selected error in PDF Document Fragman Windows Software 4 23-02-2010 04:23 PM
How to fix number of pages in word document? Jmackenz Tips & Tweaks 3 16-09-2009 08:22 AM


All times are GMT +5.5. The time now is 09:56 AM.