Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Virginia, USA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Seperating Reports in a large file (2000 SP 3)

    I receive a monthly report that has within it 25 sub reports. The first character in each line in the file is a blank except where a subreport starts. The subreport starts with the character "1". How do I first find the start of each subreport and second save the subreports to their own word document?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Seperating Reports in a large file (2000 SP 3)

    There may be more elegant ways of doing this, but try the code in the attached text file. It should be copied into a standard module in any document or template (preferably not into the report document). Modify the constant strReport as needed (you can add a path if you want.) The report should be the active document when you run the code.

    Note: the report document is modified, but its Saved property is set to True, so if you close it, the changes will not be saved.
    Attached Files Attached Files

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Seperating Reports in a large file (2000 SP 3)

    Does the file that you recieve make use of Master and Sub Documents? Is it not possible to switch to Outline view and use the Master Doc feature to open the sub documents! Once a sub document is open you can save it as a seperate file!
    Regards,
    Rudi

Posting Permissions

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