A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Print on both sides of paper from two worksheets



 
 
Thread Tools Display Modes
  #1  
Old August 15th 08, 11:03 PM posted to microsoft.public.excel.misc
SC in Texas
external usenet poster
 
Posts: 6
Default Print on both sides of paper from two worksheets

How do I get a printer that will print on both sides of the paper
automatically to do so from two worksheets in the workbook. If I have two
pages on the same worksheet it works fine or if I print to a printer that
requires the paper to be changed manually it works fine. But it the printer
handles the paper automatically it gives me two sheets with the back side
blank.
Thanks
--
SC from Lubbock, Texas
Ads
  #2  
Old August 15th 08, 11:32 PM posted to microsoft.public.excel.misc
TomPl
external usenet poster
 
Posts: 342
Default Print on both sides of paper from two worksheets

Select both sheets at the same time then hit print.
That might work?


"SC in Texas" wrote:

> How do I get a printer that will print on both sides of the paper
> automatically to do so from two worksheets in the workbook. If I have two
> pages on the same worksheet it works fine or if I print to a printer that
> requires the paper to be changed manually it works fine. But it the printer
> handles the paper automatically it gives me two sheets with the back side
> blank.
> Thanks
> --
> SC from Lubbock, Texas

  #3  
Old August 17th 08, 08:32 PM posted to microsoft.public.excel.misc
MyVeryOwnSelf
external usenet poster
 
Posts: 213
Default Print on both sides of paper from two worksheets

> How do I get a printer that will print on both sides of the paper
> automatically to do so from two worksheets in the workbook. If I have
> two pages on the same worksheet it works fine or if I print to a
> printer that requires the paper to be changed manually it works fine.
> But it the printer handles the paper automatically it gives me two
> sheets with the back side blank.


This problem annoys me too. Excel seems to treat sheets as separate
documents.

The following works for me, but it's awkward.

Print each worksheet using the "Microsoft Office Document Image Writer."
This produces an ".mdi" file for each worksheet. With both files open, it's
possible to copy pages from one into the other, merging the two into one
mdi file. Then the merged file can be printed.

For somebody doing this a lot, it might be helpful to use third-party
software like:
http://www.fineprint.com/products/fineprint/index.html
  #4  
Old August 18th 08, 05:34 PM posted to microsoft.public.excel.misc
SC in Texas
external usenet poster
 
Posts: 6
Default Print on both sides of paper from two worksheets

I am hoping that there is a way to do the print commands in code on a command
button that will make excel not treet the sheets as separate documents but
treat them as one in the print command.
With a printer that has to manually be reloaded for the second page it works
great but for the automatic ones it treats each sheet as separate documents
and not the workbook as a single document print job.
Thanks for the reply. It is good to know I am not the only one trying to
deal with this. I am trying to set this up as a template for others to use
and the multiple steps in your solution would work great for me but not for
them.
Thanks,
Steve
--
SC from Lubbock, Texas


"MyVeryOwnSelf" wrote:

> > How do I get a printer that will print on both sides of the paper
> > automatically to do so from two worksheets in the workbook. If I have
> > two pages on the same worksheet it works fine or if I print to a
> > printer that requires the paper to be changed manually it works fine.
> > But it the printer handles the paper automatically it gives me two
> > sheets with the back side blank.

>
> This problem annoys me too. Excel seems to treat sheets as separate
> documents.
>
> The following works for me, but it's awkward.
>
> Print each worksheet using the "Microsoft Office Document Image Writer."
> This produces an ".mdi" file for each worksheet. With both files open, it's
> possible to copy pages from one into the other, merging the two into one
> mdi file. Then the merged file can be printed.
>
> For somebody doing this a lot, it might be helpful to use third-party
> software like:
> http://www.fineprint.com/products/fineprint/index.html
>

  #5  
Old August 19th 08, 03:58 PM posted to microsoft.public.excel.misc
TomPl
external usenet poster
 
Posts: 342
Default Print on both sides of paper from two worksheets

If you select more that one sheet simultaneously, the multiple sheets will be
printed as one job. Code like that below will accomplish the task:

Sheets(Array("Sheet1, "Sheet2")).Printout

Best of luck.

Tom

"SC in Texas" wrote:

> I am hoping that there is a way to do the print commands in code on a command
> button that will make excel not treet the sheets as separate documents but
> treat them as one in the print command.
> With a printer that has to manually be reloaded for the second page it works
> great but for the automatic ones it treats each sheet as separate documents
> and not the workbook as a single document print job.
> Thanks for the reply. It is good to know I am not the only one trying to
> deal with this. I am trying to set this up as a template for others to use
> and the multiple steps in your solution would work great for me but not for
> them.
> Thanks,
> Steve
> --
> SC from Lubbock, Texas
>
>
> "MyVeryOwnSelf" wrote:
>
> > > How do I get a printer that will print on both sides of the paper
> > > automatically to do so from two worksheets in the workbook. If I have
> > > two pages on the same worksheet it works fine or if I print to a
> > > printer that requires the paper to be changed manually it works fine.
> > > But it the printer handles the paper automatically it gives me two
> > > sheets with the back side blank.

> >
> > This problem annoys me too. Excel seems to treat sheets as separate
> > documents.
> >
> > The following works for me, but it's awkward.
> >
> > Print each worksheet using the "Microsoft Office Document Image Writer."
> > This produces an ".mdi" file for each worksheet. With both files open, it's
> > possible to copy pages from one into the other, merging the two into one
> > mdi file. Then the merged file can be printed.
> >
> > For somebody doing this a lot, it might be helpful to use third-party
> > software like:
> > http://www.fineprint.com/products/fineprint/index.html
> >

  #6  
Old August 19th 08, 09:13 PM posted to microsoft.public.excel.misc
SC in Texas
external usenet poster
 
Posts: 6
Default Print on both sides of paper from two worksheets

Tom,
They will be printed simultaneously but Excel treats each Sheet as a
separate print job when the printer is printing front and back if the printer
does it automatically.
If the printer is a manual flip for front and back there is no problem. When
it is one that automatically flips the pages, or at least our HP's and our
Xerox Document Centre do this, the page flips then comes out without anything
printed on the back side, then prints the next workbook sheet the sameway.
If the workbook sheet has more than one page of print, it will print front
and back until it finishes that workbook sheet and then starts over with the
next workbook sheet.
I have worked around the problem by recreating my two page form on a single
workbook sheet. Would have been simpler if the printers would not see each
workbook sheet as a separate job even though they are all in the same print
command.
Thanks,
Steve
--
SC from Lubbock, Texas


"TomPl" wrote:

> If you select more that one sheet simultaneously, the multiple sheets will be
> printed as one job. Code like that below will accomplish the task:
>
> Sheets(Array("Sheet1, "Sheet2")).Printout
>
> Best of luck.
>
> Tom
>
> "SC in Texas" wrote:
>
> > I am hoping that there is a way to do the print commands in code on a command
> > button that will make excel not treet the sheets as separate documents but
> > treat them as one in the print command.
> > With a printer that has to manually be reloaded for the second page it works
> > great but for the automatic ones it treats each sheet as separate documents
> > and not the workbook as a single document print job.
> > Thanks for the reply. It is good to know I am not the only one trying to
> > deal with this. I am trying to set this up as a template for others to use
> > and the multiple steps in your solution would work great for me but not for
> > them.
> > Thanks,
> > Steve
> > --
> > SC from Lubbock, Texas
> >
> >
> > "MyVeryOwnSelf" wrote:
> >
> > > > How do I get a printer that will print on both sides of the paper
> > > > automatically to do so from two worksheets in the workbook. If I have
> > > > two pages on the same worksheet it works fine or if I print to a
> > > > printer that requires the paper to be changed manually it works fine.
> > > > But it the printer handles the paper automatically it gives me two
> > > > sheets with the back side blank.
> > >
> > > This problem annoys me too. Excel seems to treat sheets as separate
> > > documents.
> > >
> > > The following works for me, but it's awkward.
> > >
> > > Print each worksheet using the "Microsoft Office Document Image Writer."
> > > This produces an ".mdi" file for each worksheet. With both files open, it's
> > > possible to copy pages from one into the other, merging the two into one
> > > mdi file. Then the merged file can be printed.
> > >
> > > For somebody doing this a lot, it might be helpful to use third-party
> > > software like:
> > > http://www.fineprint.com/products/fineprint/index.html
> > >

  #7  
Old August 19th 08, 10:04 PM posted to microsoft.public.excel.misc
TomPl
external usenet poster
 
Posts: 342
Default Print on both sides of paper from two worksheets

I just tested it printing to an HP printer.

Sheet1 is selected. Holding the Ctrl or Shift key I selected Sheet2. Now
both Sheet1 and Sheet2 are selected. Hit the print button and sheet1 is
printed to side A and Sheet2 is printed to side B.

Note: Both sheets must have the printer options set to double sided printing.

Maybe this time.

Tom

"SC in Texas" wrote:

> Tom,
> They will be printed simultaneously but Excel treats each Sheet as a
> separate print job when the printer is printing front and back if the printer
> does it automatically.
> If the printer is a manual flip for front and back there is no problem. When
> it is one that automatically flips the pages, or at least our HP's and our
> Xerox Document Centre do this, the page flips then comes out without anything
> printed on the back side, then prints the next workbook sheet the sameway.
> If the workbook sheet has more than one page of print, it will print front
> and back until it finishes that workbook sheet and then starts over with the
> next workbook sheet.
> I have worked around the problem by recreating my two page form on a single
> workbook sheet. Would have been simpler if the printers would not see each
> workbook sheet as a separate job even though they are all in the same print
> command.
> Thanks,
> Steve
> --
> SC from Lubbock, Texas
>
>
> "TomPl" wrote:
>
> > If you select more that one sheet simultaneously, the multiple sheets will be
> > printed as one job. Code like that below will accomplish the task:
> >
> > Sheets(Array("Sheet1, "Sheet2")).Printout
> >
> > Best of luck.
> >
> > Tom
> >
> > "SC in Texas" wrote:
> >
> > > I am hoping that there is a way to do the print commands in code on a command
> > > button that will make excel not treet the sheets as separate documents but
> > > treat them as one in the print command.
> > > With a printer that has to manually be reloaded for the second page it works
> > > great but for the automatic ones it treats each sheet as separate documents
> > > and not the workbook as a single document print job.
> > > Thanks for the reply. It is good to know I am not the only one trying to
> > > deal with this. I am trying to set this up as a template for others to use
> > > and the multiple steps in your solution would work great for me but not for
> > > them.
> > > Thanks,
> > > Steve
> > > --
> > > SC from Lubbock, Texas
> > >
> > >
> > > "MyVeryOwnSelf" wrote:
> > >
> > > > > How do I get a printer that will print on both sides of the paper
> > > > > automatically to do so from two worksheets in the workbook. If I have
> > > > > two pages on the same worksheet it works fine or if I print to a
> > > > > printer that requires the paper to be changed manually it works fine.
> > > > > But it the printer handles the paper automatically it gives me two
> > > > > sheets with the back side blank.
> > > >
> > > > This problem annoys me too. Excel seems to treat sheets as separate
> > > > documents.
> > > >
> > > > The following works for me, but it's awkward.
> > > >
> > > > Print each worksheet using the "Microsoft Office Document Image Writer."
> > > > This produces an ".mdi" file for each worksheet. With both files open, it's
> > > > possible to copy pages from one into the other, merging the two into one
> > > > mdi file. Then the merged file can be printed.
> > > >
> > > > For somebody doing this a lot, it might be helpful to use third-party
> > > > software like:
> > > > http://www.fineprint.com/products/fineprint/index.html
> > > >

  #8  
Old September 5th 08, 02:41 PM posted to microsoft.public.excel.misc
basic
external usenet poster
 
Posts: 23
Default Print on both sides of paper from two worksheets

I also was looking for a solution to this and TomPl is correct, follow his
directions and it should work.

Thanks!

"TomPl" wrote:

> I just tested it printing to an HP printer.
>
> Sheet1 is selected. Holding the Ctrl or Shift key I selected Sheet2. Now
> both Sheet1 and Sheet2 are selected. Hit the print button and sheet1 is
> printed to side A and Sheet2 is printed to side B.
>
> Note: Both sheets must have the printer options set to double sided printing.
>
> Maybe this time.
>
> Tom
>
> "SC in Texas" wrote:
>
> > Tom,
> > They will be printed simultaneously but Excel treats each Sheet as a
> > separate print job when the printer is printing front and back if the printer
> > does it automatically.
> > If the printer is a manual flip for front and back there is no problem. When
> > it is one that automatically flips the pages, or at least our HP's and our
> > Xerox Document Centre do this, the page flips then comes out without anything
> > printed on the back side, then prints the next workbook sheet the sameway.
> > If the workbook sheet has more than one page of print, it will print front
> > and back until it finishes that workbook sheet and then starts over with the
> > next workbook sheet.
> > I have worked around the problem by recreating my two page form on a single
> > workbook sheet. Would have been simpler if the printers would not see each
> > workbook sheet as a separate job even though they are all in the same print
> > command.
> > Thanks,
> > Steve
> > --
> > SC from Lubbock, Texas
> >
> >
> > "TomPl" wrote:
> >
> > > If you select more that one sheet simultaneously, the multiple sheets will be
> > > printed as one job. Code like that below will accomplish the task:
> > >
> > > Sheets(Array("Sheet1, "Sheet2")).Printout
> > >
> > > Best of luck.
> > >
> > > Tom
> > >
> > > "SC in Texas" wrote:
> > >
> > > > I am hoping that there is a way to do the print commands in code on a command
> > > > button that will make excel not treet the sheets as separate documents but
> > > > treat them as one in the print command.
> > > > With a printer that has to manually be reloaded for the second page it works
> > > > great but for the automatic ones it treats each sheet as separate documents
> > > > and not the workbook as a single document print job.
> > > > Thanks for the reply. It is good to know I am not the only one trying to
> > > > deal with this. I am trying to set this up as a template for others to use
> > > > and the multiple steps in your solution would work great for me but not for
> > > > them.
> > > > Thanks,
> > > > Steve
> > > > --
> > > > SC from Lubbock, Texas
> > > >
> > > >
> > > > "MyVeryOwnSelf" wrote:
> > > >
> > > > > > How do I get a printer that will print on both sides of the paper
> > > > > > automatically to do so from two worksheets in the workbook. If I have
> > > > > > two pages on the same worksheet it works fine or if I print to a
> > > > > > printer that requires the paper to be changed manually it works fine.
> > > > > > But it the printer handles the paper automatically it gives me two
> > > > > > sheets with the back side blank.
> > > > >
> > > > > This problem annoys me too. Excel seems to treat sheets as separate
> > > > > documents.
> > > > >
> > > > > The following works for me, but it's awkward.
> > > > >
> > > > > Print each worksheet using the "Microsoft Office Document Image Writer."
> > > > > This produces an ".mdi" file for each worksheet. With both files open, it's
> > > > > possible to copy pages from one into the other, merging the two into one
> > > > > mdi file. Then the merged file can be printed.
> > > > >
> > > > > For somebody doing this a lot, it might be helpful to use third-party
> > > > > software like:
> > > > > http://www.fineprint.com/products/fineprint/index.html
> > > > >

  #9  
Old February 10th 10, 03:38 PM posted to microsoft.public.excel.misc
Bones[_2_]
external usenet poster
 
Posts: 1
Default Brilliant

Tom,

Thanks for helping on this. My second sheet was at a different orientation and I had tried just about every combination I could think of between my computer and the printer to try and get the two sheets on one double-sided page.

The trick was enabling two-sided printing on both sheets separately. Just brilliant.



TomP wrote:

I just tested it printing to an HP printer.Sheet1 is selected.
19-Aug-08

I just tested it printing to an HP printer.

Sheet1 is selected. Holding the Ctrl or Shift key I selected Sheet2. Now
both Sheet1 and Sheet2 are selected. Hit the print button and sheet1 is
printed to side A and Sheet2 is printed to side B.

Note: Both sheets must have the printer options set to double sided printing.

Maybe this time.

Tom

"SC in Texas" wrote:

Previous Posts In This Thread:

On Friday, August 15, 2008 6:03 PM
SCinTexa wrote:

Print on both sides of paper from two worksheets
How do I get a printer that will print on both sides of the paper
automatically to do so from two worksheets in the workbook. If I have two
pages on the same worksheet it works fine or if I print to a printer that
requires the paper to be changed manually it works fine. But it the printer
handles the paper automatically it gives me two sheets with the back side
blank.
Thanks
--
SC from Lubbock, Texas

On Friday, August 15, 2008 6:32 PM
TomP wrote:

Select both sheets at the same time then hit print.That might work?
Select both sheets at the same time then hit print.
That might work?


"SC in Texas" wrote:

On Sunday, August 17, 2008 3:32 PM
MyVeryOwnSelf wrote:

This problem annoys me too. Excel seems to treat sheets as separate documents.
This problem annoys me too. Excel seems to treat sheets as separate
documents.

The following works for me, but it's awkward.

Print each worksheet using the "Microsoft Office Document Image Writer."
This produces an ".mdi" file for each worksheet. With both files open, it's
possible to copy pages from one into the other, merging the two into one
mdi file. Then the merged file can be printed.

For somebody doing this a lot, it might be helpful to use third-party
software like:
http://www.fineprint.com/products/fineprint/index.html

On Monday, August 18, 2008 12:34 PM
SCinTexa wrote:

I am hoping that there is a way to do the print commands in code on a command
I am hoping that there is a way to do the print commands in code on a command
button that will make excel not treet the sheets as separate documents but
treat them as one in the print command.
With a printer that has to manually be reloaded for the second page it works
great but for the automatic ones it treats each sheet as separate documents
and not the workbook as a single document print job.
Thanks for the reply. It is good to know I am not the only one trying to
deal with this. I am trying to set this up as a template for others to use
and the multiple steps in your solution would work great for me but not for
them.
Thanks,
Steve
--
SC from Lubbock, Texas


"MyVeryOwnSelf" wrote:

On Tuesday, August 19, 2008 10:58 AM
TomP wrote:

If you select more that one sheet simultaneously, the multiple sheets will be
If you select more that one sheet simultaneously, the multiple sheets will be
printed as one job. Code like that below will accomplish the task:

Sheets(Array("Sheet1, "Sheet2")).Printout

Best of luck.

Tom

"SC in Texas" wrote:

On Tuesday, August 19, 2008 4:13 PM
SCinTexa wrote:

Tom,They will be printed simultaneously but Excel treats each Sheet as a
Tom,
They will be printed simultaneously but Excel treats each Sheet as a
separate print job when the printer is printing front and back if the printer
does it automatically.
If the printer is a manual flip for front and back there is no problem. When
it is one that automatically flips the pages, or at least our HP's and our
Xerox Document Centre do this, the page flips then comes out without anything
printed on the back side, then prints the next workbook sheet the sameway.
If the workbook sheet has more than one page of print, it will print front
and back until it finishes that workbook sheet and then starts over with the
next workbook sheet.
I have worked around the problem by recreating my two page form on a single
workbook sheet. Would have been simpler if the printers would not see each
workbook sheet as a separate job even though they are all in the same print
command.
Thanks,
Steve
--
SC from Lubbock, Texas


"TomPl" wrote:

On Tuesday, August 19, 2008 5:04 PM
TomP wrote:

I just tested it printing to an HP printer.Sheet1 is selected.
I just tested it printing to an HP printer.

Sheet1 is selected. Holding the Ctrl or Shift key I selected Sheet2. Now
both Sheet1 and Sheet2 are selected. Hit the print button and sheet1 is
printed to side A and Sheet2 is printed to side B.

Note: Both sheets must have the printer options set to double sided printing.

Maybe this time.

Tom

"SC in Texas" wrote:

On Friday, September 05, 2008 9:41 AM
basi wrote:

I also was looking for a solution to this and TomPl is correct, follow his
I also was looking for a solution to this and TomPl is correct, follow his
directions and it should work.

Thanks!

"TomPl" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Creating a WPF Custom Control
http://www.eggheadcafe.com/tutorials...ustom-con.aspx
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
I am trying to print index cards with exell both sides Kevin Excel Discussion (Misc queries) 0 January 4th 08 06:51 PM
how to print a complete workbook with multiple tabs on both sides Michel Drouin Excel Worksheet Functions 0 May 9th 06 07:41 PM
Print a range on multiple worksheets on one sheet of paper? RoyalStreet Excel Worksheet Functions 2 March 1st 06 05:25 PM
How can I print current row in same place on paper but not print surrounding cells??? Andy Ford New Users to Excel 1 September 2nd 05 05:50 AM
i want to print using both sides of A4 sheet Rox Excel Discussion (Misc queries) 4 August 8th 05 09:01 PM


All times are GMT +1. The time now is 02:15 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.