• 0

VBA - Spell Checking Object?


Question

Ok, I need to do some string analysis on a column in Excel. The column contains a bunch of strings that need to be compared against a list of strings I have in an Access database. I was considering writing a drawn out string comparison routine, but then I got to thinking about how I could save some time and it occured to me that if a Spell Checking Object existed out there it may be what I need.

I was hoping that Microsoft would give me access to the same object they use throughout office. Maybe it is barried in ActiveX or something. I'm not really sure how to get to the help about how to use it.

What I basically want to do is:

Load up all the strings from my Access database as I guess "words" in a custom dictionary for the spell checker.

Run the spell checking over my Excel spreadsheet with only those words (throw out the default "English" dictionary). Then little squiggles would appear over the Excel cells that are not in my list comming from my Access database. The user can right-click them and get a list of suggested words (from the Access database).

Any thoughts?

For those that are curious. My Access database has a list of "Trade Names" of manufactured materials from various manufacturers around the world. There is a lot of data within the Excel spreadsheet we want to merge with out database, but we are having some stupid string problems where there are 2 instances of a Trade Name, when there should only be 1.

Thanks for your time!

-Nic

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.