Author Topic: Printing reports - double sided  (Read 19777 times)

0 Members and 10 Guests are viewing this topic.

Offline bahhumbug

  • Board Veteran
  • *****
  • Posts: 3030
  • What ? Replace my quill with a what ? ! BAH !!
Printing reports - double sided
« on: June 15, 2009, 10:06:58 AM »
They want to print pupils' reports double sided.
 
We don't have a printer that has the automatic double sided printing facility.
 
The manual way is a possibility (Even sides, turn the printouts, then Odd sides)
but SIMS doesn't seem to offer any printing dialogue box to facilitate this.
 
The files can be exported. They come out as .xml files which Word will open but for the manual method of printing double sided they'd have to be concatenated and I don't know of any way of doing that.
 
Am I missing something simple ?

Sign by Danasoft - Get Your Free Sign

Offline nema

  • Full Member
  • ***
  • Posts: 169
  • Gender: Male
Re: Printing reports - double sided
« Reply #1 on: June 15, 2009, 11:08:15 AM »
Once they are exported to .xml files is it possible to use a modified macro to print them all at once double sided?

Something based on this:

Public Sub printfiles()
    With Application.FileSearch
        .LookIn = "D:\somewhere\doc files\"             ' where to search
        .SearchSubFolders = True    ' search the subfolders
        .FileName = "*.xml"         ' file pattern to match

        ' if more than one match, execute the following code
        If .Execute() > 0 Then
            ' to display how many files this macro will access,
            ' uncomment the next line of code
'            MsgBox "Found " & .FoundFiles.Count & " file(s)."

            ' for each file you find, run this loop
            For i = 1 To .FoundFiles.Count
                ' open the file based on its index position
                Documents.Open FileName:=.FoundFiles(i)

                ' print file
                Application.PrintOut FileName:="", Range:=wdPrintAllDocument, Item:= _
        wdPrintDocumentContent, Copies:=1, Pages:="", PageType:=wdPrintAllPages, _
        ManualDuplexPrint:=False, Collate:=True, Background:=True, PrintToFile:= _
        False, PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0, _
        PrintZoomPaperHeight:=0

                ' save and close the current document
                ActiveDocument.Close wdSaveChanges
            Next i
        Else
            ' if the system cannot find any files
            ' with the .xml extension
            MsgBox "No files found."
        End If
    End With
End Sub

Offline bahhumbug

  • Board Veteran
  • *****
  • Posts: 3030
  • What ? Replace my quill with a what ? ! BAH !!
Re: Printing reports - double sided
« Reply #2 on: June 15, 2009, 11:53:08 AM »
That looks like a great help nema ......
 
except........
 
VB      ... doh !   ::)
 
K I've edited it to look in the correct document folder.
 
So then I ran it to see where it would trip up guessing that that would tell me where I have to edit it next ...
 
So I get a runtime error ...Incorrect document syntax..located here .........
 
Documents.Open FileName:=.FoundFiles(i)
 
but I don't know what to put in there
 
You may have to talk me thru' this slowly nema  :-\

Sign by Danasoft - Get Your Free Sign

Offline nema

  • Full Member
  • ***
  • Posts: 169
  • Gender: Male
Re: Printing reports - double sided
« Reply #3 on: June 15, 2009, 12:03:26 PM »
I run the script through WORD (Tools, macro, visual basic editor).  I have not modified it to print back to back (I would need to play with it but I think it is possible).

The script runs fine for me with no error.  Are you testing it with .xml files?

Offline nema

  • Full Member
  • ***
  • Posts: 169
  • Gender: Male
Re: Printing reports - double sided
« Reply #4 on: June 15, 2009, 12:11:48 PM »
changing

ManualDuplexPrint:=False

to

ManualDuplexPrint:=True

Seems to print double sided but I am not sure if it outputs the pages correctly.  Needs more head scratching.

Offline Telone

  • Board Veteran
  • *****
  • Posts: 1890
  • Gender: Male
Re: Printing reports - double sided
« Reply #5 on: June 15, 2009, 12:20:58 PM »
Bah
 
Do you not have any C2k hp 2300 Dn printers the D stands for duplex, that is what we used for printing double sided.  ???
Did You Hear about the Dyslexic Devil Worshiper

He Sold his Soul to Santa

Rebooting is a wonder drug - it fixes almost everything.

99.9% of Politicians Give the Rest a Bad Name

Offline Snoop55

  • Valued Contributor
  • ****
  • Posts: 709
  • Gender: Male
    • http://www.loretocollege.org.uk
Re: Printing reports - double sided
« Reply #6 on: June 15, 2009, 12:36:46 PM »
Bah
 
Do you not have any C2k hp 2300 Dn printers the D stands for duplex, that is what we used for printing double sided.  ???


That's what we use here Telone.  I gave the office staff access to one of our 2300s and it's simply a matter of ticking the print on both sides option in the printer settings.
I don't make mistakes. I make prophecies which immediately turn out to be wrong.
Murray Walker

Offline dfinney

  • Technicians
  • Board Veteran
  • *****
  • Posts: 1906
  • Gender: Male
    • Wallace high school
Re: Printing reports - double sided
« Reply #7 on: June 15, 2009, 12:40:17 PM »
Doing this here today as well, we just print them out on two pages on recycled paper then feed it through are big colour photocopier and tell it to do the double sided printing for us.

Teachers then have a look over the two pages for mistakes and report back to me if there are any and i fix them and print them doublesided manually if there are not many.
"Education is a progressive discovery of our own ignorance."

Offline bahhumbug

  • Board Veteran
  • *****
  • Posts: 3030
  • What ? Replace my quill with a what ? ! BAH !!
Re: Printing reports - double sided
« Reply #8 on: June 15, 2009, 12:48:00 PM »
K .. it works now ...... almost
 
(simple thing I was doin wrong which isn't important for now)
 
but it doesn't print them in duplex (I'd guess 'cos as I said we don't have a printer with duplex printing capability)
 
Could the macro be edited to print like this for example......
 
print the first page of each document
 
then pause for input (press enter eg)
 
print the second page of each document

Sign by Danasoft - Get Your Free Sign

Offline bahhumbug

  • Board Veteran
  • *****
  • Posts: 3030
  • What ? Replace my quill with a what ? ! BAH !!
Re: Printing reports - double sided
« Reply #9 on: June 15, 2009, 01:00:03 PM »
Tel/Snoop, did you buy your 2300 Dn printers ?
 
Us peasants just have to rely on what C2k dole out to us  :)

Sign by Danasoft - Get Your Free Sign

Offline nema

  • Full Member
  • ***
  • Posts: 169
  • Gender: Male
Re: Printing reports - double sided
« Reply #10 on: June 15, 2009, 01:01:08 PM »
Try changing

Pages:=""

to

Pages:="1"

run it

then

Pages:="2"

run in, etc

not very elegant

Offline nema

  • Full Member
  • ***
  • Posts: 169
  • Gender: Male
Re: Printing reports - double sided
« Reply #11 on: June 15, 2009, 01:04:35 PM »
actually, that dosn't work

hmmmm

Offline bahhumbug

  • Board Veteran
  • *****
  • Posts: 3030
  • What ? Replace my quill with a what ? ! BAH !!
Re: Printing reports - double sided
« Reply #12 on: June 15, 2009, 01:11:09 PM »
nema, thanks for trying but don't spend too much time on it.
 
The answer,
if......
 they want the reports printed in colour, and it's basically the school badge is all, is to
 
print it to headed paper
 
replace the headed paper in the photocopier ....
 
copy the other side to the headed paper
 
else buy duplex colour printer
 
 ;D
« Last Edit: June 15, 2009, 01:13:59 PM by bahhumbug »

Sign by Danasoft - Get Your Free Sign

Offline nema

  • Full Member
  • ***
  • Posts: 169
  • Gender: Male
Re: Printing reports - double sided
« Reply #13 on: June 15, 2009, 01:11:32 PM »
but it DOES work if you change

Range:=wdPrintAllDocument

to

Range:=wdPrintRangeOfPages

then do the Pages:="1" thing i mentioned above



Offline nema

  • Full Member
  • ***
  • Posts: 169
  • Gender: Male
Re: Printing reports - double sided
« Reply #14 on: June 15, 2009, 01:13:23 PM »
it was no bother to be distracted while I waited
« Last Edit: June 15, 2009, 01:24:38 PM by nema »