Results 1 to 7 of 7
  1. #1
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Advice (Word 97SR2)

    I've got a Word document the contents of which is one big table (17 or so pages). I want to write a report on the contents of the table. If the data were in Access the report would be finished and this post never conceived, but since it's in Word I'm wondering what's the best approach.

    Should I export the data to Access or Excel or does Word have amazing report writing capabilities that I am unaware of??? ("of which I am unaware", for all you English majors out there)
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  2. #2
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,048
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: Report Advice (Word 97SR2)

    On a copy of your document try the Tools => AutoSummarize feature. Sometimes this brings really interesting and useful results. Other times, it's so much gibberish. Which may depend on how well styles were used in writing the document.
    Charles Kyle Kenyon
    Madison, Wisconsin

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Advice (Word 97SR2)

    tried your suggestion and all it did was to highlight (in yellow) the contents of all cells. Is something supposed to happen after that?
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  4. #4
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,048
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: Report Advice (Word 97SR2)

    Its supposed to do what its supposed to do...

    Which is another way of saying is I guess it didn't help here.

    Depending on how the document is set up, Autosummarize sometimes produces a helpful summary. Other times, not.
    Charles Kyle Kenyon
    Madison, Wisconsin

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Advice (Word 97SR2)

    Definitely a Not. But thanks for trying. You never know. Maybe it would produce something of interest for another doc.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Advice (Word 97SR2)

    Hi Kevin:

    I got this from an issue of WOW & the article was written by Bill Coan, MVP.

    Macro: AutoSummarize
    WOW by Bill Coan
    Here's how to customize Word's AutoSummarize function for maximum speed:

    1. On the Tools menu, choose Macro | Macros...
    2. Under Macro Name, enter ToolsAutoSummarize and click Create.
    3. Edit Word's version of the macro text to read exactly as follows:

    Sub ToolsAutoSummarize()
    On Error Resume Next
    With ActiveDocument
    If .ShowSummary = True Then
    .ShowSummary = False
    Else
    .SummaryViewMode = wdSummaryModeHideAllButSummary
    .SummaryLength = 25
    .ShowSummary = True
    End If
    EndWith
    End Sub

    -OR-

    Sub ToolsAutoSummarize()
    On Error Resume Next
    With ActiveDocument
    If .ShowSummary = True Then
    .ShowSummary = False
    Else
    .SummaryViewMode = wdSummaryModeHighlight
    .SummaryLength = 25
    .ShowSummary = True
    End If
    EndWith
    End Sub


    4. Press Alt+F11 to return to Word.
    5. On the Tools menu, choose Customize and then choose Commands.
    6. In the Categories list, choose All Commands.
    7. In the Commands list, scroll down to ToolsAutoSummarize.
    8. Drag ToolsAutoSummarize out of the list and up to a toolbar.
    9. Drop ToolsAutoSummarize on your favorite toolbar.
    10. Close the Customize dialog box.

    That's all there is to it. To view a summary of a document, simply open it and click your new toolbar button . To return to the full document, click the same button again. Fast, eh? You bet! Now you've got a tool that saves time just when time is most critical to you.

    Before stopping to pat yourself on the back, why not explore a couple of modifications? Perhaps you'd like to see key sentences in context, highlighted in yellow. Perhaps you'd like to include fewer sentences. To accomplish these changes, proceed as follows:

    Press Alt+F11 to return to the macro edtor.
    Delete the following lines of code from your macro:

    .SummaryViewMode = wdSummaryModeHideAllButSummary .SummaryLength = 25

    Insert the following lines of code in place of the deleted lines:

    .SummaryViewMode = wdSummaryModeHighlight
    .SummaryLength = 15

    Press Alt+F11 to return to Word and test the results.
    Repeat Steps 1 - 4 to restore the original lines of code.
    How does Word's AutoSummarize function work?
    First it analyzes your document and determines key points by assigning a score to each sentence. Sentences that contain words used frequently in the document are given a higher score. A percentage of the highest-scoring sentences are displayed in the summary.

    According to Microsoft, AutoSummarize works best on well-structured documents, including reports, articles, and scientific papers. Personally, I find that it works well on correspondence and lengthy newsletter articles.

    Hope this helps.

  7. #7
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Advice (Word 97SR2)

    Phil,

    That code is tres cool and I think I'll put that in the toolkit.

    But what I really wanted to know is what's the best way create a nice report from a Word file with one long table of information? At this point, I'm going to convert the table to an Access mdb and create the report in Access.

    So, unless there's some wisdom here on a better approach, I guess I'll post to Access for advice on importing a Word table into an mdb.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

Posting Permissions

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