+ Reply to Thread
Results 1 to 13 of 13

index for all file words

  1. #1
    Registered User
    Join Date
    10-03-2009
    Location
    cairo
    MS-Off Ver
    Excel 2003
    Posts
    33

    index for all file words

    hi all
    i have book that i want to make an index for it.
    i am using the normal way which to mark the words one by one and after all i set the index at the end of last page.

    my question has two parts:
    first : is there any way to mark all the words of file without repeat and make the index for them all ?
    second: how to put the number of frequency for every word at the end of it's line ?

    hope to be cleared ,and most to find help from kind people like you

    kind regards
    sherif
    Last edited by sherif; 11-08-2011 at 05:50 PM.

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: index for all file words

    You can make a list of all words to be indexed in a separate Word-document.
    It's been called a 'concordance table'.
    If you use the index wizard there's an option to use this table.
    Last edited by snb; 11-08-2011 at 04:31 AM.



  3. #3
    Registered User
    Join Date
    10-03-2009
    Location
    cairo
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: index for all file words

    ok
    but i don't want to make index for specific words , i want them all ,
    any way i made some youtube browsing and i found free program on this site :
    http://www.chrisgreaves.com/indxr.ca/
    i am working on it to find how it works
    any way ,thank you so much

  4. #4
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: index for all file words

    Hello,

    Maybe something like this is what you are after.

    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  5. #5
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: index for all file words

    Extremely simple:

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    10-03-2009
    Location
    cairo
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: index for all file words

    hi snb
    fantastic code ,it separate every word in document in line , so fast and simple
    is there any way to make the code remove the duplicated words ?
    thanks for help
    kind regards

  7. #7
    Registered User
    Join Date
    10-03-2009
    Location
    cairo
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: index for all file words

    i found pdf file through Microsoft explains how to make a concordance file
    it's attached here for interested people

    http://janetunderwood.com/Microsoft%...oncordance.pdf
    thanks

  8. #8
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: index for all file words

    The result should be a list of unique words.

    which duplicates do you find ? (uppercase/lowercase ?)

    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    10-03-2009
    Location
    cairo
    MS-Off Ver
    Excel 2003
    Posts
    33

    Smile Re: index for all file words

    WOW WOW
    it works , what fantastic code,amazing effort.
    is any way to remove dot and commas automatically through code ?
    any way your effort is really appreciated
    thank you so much
    Last edited by romperstomper; 11-08-2011 at 08:55 AM. Reason: remove quote

  10. #10
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: index for all file words

    Please Login or Register  to view this content.
    Last edited by snb; 11-08-2011 at 12:50 PM.

  11. #11
    Registered User
    Join Date
    10-03-2009
    Location
    cairo
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: index for all file words

    Quote Originally Posted by snb View Post
    Please Login or Register  to view this content.
    it works perfectly
    thank you so much

  12. #12
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: index for all file words

    I'm new to the forum, but not new to Word. How about:
    Please Login or Register  to view this content.
    This sub puts the word list, with frequency count, at the end of the document - starting on a new page. The 'unwanted' character exlusion set (defined by the StrIn = Replace(StrIn, Chr(i), " ") processes) is fairly comprehensive. Adding a word exclusions list (to omit certain words from the concordance), is quite simple.
    Last edited by macropod; 12-22-2011 at 08:17 AM.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  13. #13
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: index for all file words

    Hello Paul and welcome to the forum. Your insight and expertise are always welcomed.

    abousetta

+ 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