Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: macro prints too many copies

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Madison, Georgia
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I use a macro to automatically print or e-mail a workbook:

    Application.OnTime TimeValue("06:55:00"), "Print_Out",

    where "Print_Out" is a macro that actually does the printing:

    ActiveWindow.SmallScroll ToRight:=-1
    ActiveWindow.SmallScroll Down:=-1
    Range("B2:P32").Select
    ActiveWindow.SelectedSheets.PrintOut , Collate:=True

    The problem is that I get multiple copies of the same book, but I have specified only 1 in the print macro. It does the same thing when I e-mail, it spits out say 4 copies of the same thing.
    Any help is so greatly appreciated !

    [ This Message was edited by: sparks on 2002-03-23 06:25 ]

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Post your "Print_Out" code

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try this:

    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

    Regards,

    Juan Pablo González
    http://www.juanpg.com

  4. #4
    New Member
    Join Date
    Mar 2002
    Location
    Madison, Georgia
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried:
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

    Still printed out 2 copies.
    Will this macro run as many times as it can in 1 second ??

    Need to include something to tell it to run the macro at the time specified, only 1 time.

  5. #5
    New Member
    Join Date
    Mar 2002
    Location
    Holland
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Put a wait-command in your print_out macro to make it wait for at least 1 second.

    Ton

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •