+ Reply to Thread
Results 1 to 2 of 2

vba and online dictionary

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

    vba and online dictionary

    Hi,

    Don't know if anyone has come across something like this before or not. Here goes. I have a long list of words in a column (e.g. Random, Randomize, Randomized, Randomise, Randomised). What I want to do is get to the root of the word and count them. The perfect answer would be Random* = 4.

    I have though of creating a sequence from each word and checking it against all other words in the list for partial matches. For example the word random can be thought of as:

    R*
    Ra*
    Ran*
    Rand*
    Rando*
    Random*

    The first five permutations are not actual words but vba won't recognize this. Aside from creating my own database of words, is there a way to check if the term is actually a word in the English dictionary online or not?

    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.

  2. #2
    Valued Forum Contributor StevenM's Avatar
    Join Date
    03-23-2008
    Location
    New Lenox, IL USA
    MS-Off Ver
    2007
    Posts
    910

    Re: vba and online dictionary

    One could try something like:

    Please Login or Register  to view this content.
    For a free spell-checking dictionary see: http://www.winedt.org/Dict/

+ 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