+ Reply to Thread
Results 1 to 3 of 3

Code fore Sending Multiple Reports to PrintPreview Window

  1. #1
    Registered User
    Join Date
    10-11-2008
    Location
    New Jersey
    Posts
    8

    Code fore Sending Multiple Reports to PrintPreview Window

    I have 10 reports (each in a sheet), and a user box with 10 checkboxes. User checks any combination of the 10 reports and then clicks on "Print Selected Reports". I need help writing a macro that would take every report checked and send them together to Print Preview.

    I tried using the If Then Else structure, but I think it's pretty much impossible to account for every combination of reports. Basically the macro must take all of the checked reports and add them to an array where it looks like this:

    Please Login or Register  to view this content.
    But i need help figuring out how to add each report to the array. Or maybe there is a better way? Any help is really appreciated!
    Last edited by DaniilK; 09-26-2009 at 08:28 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Need Help Writing Macro

    Plase take a few minutes to (re)read the forum rules, and then edit you post to add code tags and amend the thread title accordingly.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    10-11-2008
    Location
    New Jersey
    Posts
    8

    Re: Code fore Sending Multiple Reports to PrintPreview Window

    I've updated the title and added code tags. Can anyone help me with figuring this code out please?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1