#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default synonyms

i required your help in this regard.. it may be silly/hard? for you...

that.. if i wrote "great" in Cell A2, i want Great's synonyms in B2.... and
also if there is any spelling mistake .. thats too want to know in C2 ( or
Great)

thanks in advance
Great regards,
suresh tp



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default synonyms

Do you have a synonym dictionary.

One I checked provided:

admirable, ample, august, avid, big, capital, celebrated, chief,
consequential, considerable, critical, deep, desperate, dignified,
distinguished, eager, eminent, enceinte, enormous, exalted, expectant,
extensive, extreme, famed, famous, fantastic, far-out, fine, gigantic, good,
grand, gravid, gross, heavy, high, honourable, huge, illustrious, immense,
important, large, leading, lofty, main, majuscule, marvellous, marvelous,
mighty, monstrous, monumental, noble, notable, noteworthy, outstanding,
princely, principal, prominent, remarkable, renowned, serious, splendid,
strong, terrific, towering, vast, weighty, with child, wonderful, zealous

or did you mean anagrams?

--
Regards,
Tom Ogilvy



"SURESH" wrote in message
...
i required your help in this regard.. it may be silly/hard? for you...

that.. if i wrote "great" in Cell A2, i want Great's synonyms in B2....

and
also if there is any spelling mistake .. thats too want to know in C2 ( or
Great)

thanks in advance
Great regards,
suresh tp





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default synonyms

Dear Tom

nothing i am having except Microsoft office... in MS-word when getting any
doubt i am going to get synonyms from dictionery (Shift+F7)
i am talking about this... as simple as that i want it in Excel

thanks and regards,
suresh tp

"Tom Ogilvy" wrote in message
...
Do you have a synonym dictionary.

One I checked provided:

admirable, ample, august, avid, big, capital, celebrated, chief,
consequential, considerable, critical, deep, desperate, dignified,
distinguished, eager, eminent, enceinte, enormous, exalted, expectant,
extensive, extreme, famed, famous, fantastic, far-out, fine, gigantic,

good,
grand, gravid, gross, heavy, high, honourable, huge, illustrious, immense,
important, large, leading, lofty, main, majuscule, marvellous, marvelous,
mighty, monstrous, monumental, noble, notable, noteworthy, outstanding,
princely, principal, prominent, remarkable, renowned, serious, splendid,
strong, terrific, towering, vast, weighty, with child, wonderful, zealous

or did you mean anagrams?

--
Regards,
Tom Ogilvy



"SURESH" wrote in message
...
i required your help in this regard.. it may be silly/hard? for you...

that.. if i wrote "great" in Cell A2, i want Great's synonyms in B2....

and
also if there is any spelling mistake .. thats too want to know in C2

( or
Great)

thanks in advance
Great regards,
suresh tp







  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default synonyms

Here is some starter code I found for you


Public Sub SynonymFind1()
' revised by tom ogilvy
Dim wdApp As Word.Application
Set wdApp = New Word.Application
vSyn = Application.Proper(ActiveCell.Text)
On Error GoTo ErrHandler
If wdApp.SynonymInfo(Word:=vSyn, _
LanguageID:=wdEnglishUS).Found = True _
And wdApp.SynonymInfo(Word:=vSyn, _
LanguageID:=wdEnglishUS).MeaningCount 0 Then
vList = SynonymInfo(Word:=vSyn, _
LanguageID:=wdEnglishUS).SynonymList(1)
For i = 1 To UBound(vList)
ActiveCell.Offset(0, i).Value = vList(i)
Next i
End If
ErrHandler:
wdApp.Quit
MsgBox ("FINISHED")
End Sub


--
Regards,
Tom Ogilvy

"SURESH" wrote in message
...
Dear Tom

nothing i am having except Microsoft office... in MS-word when getting any
doubt i am going to get synonyms from dictionery (Shift+F7)
i am talking about this... as simple as that i want it in Excel

thanks and regards,
suresh tp

"Tom Ogilvy" wrote in message
...
Do you have a synonym dictionary.

One I checked provided:

admirable, ample, august, avid, big, capital, celebrated, chief,
consequential, considerable, critical, deep, desperate, dignified,
distinguished, eager, eminent, enceinte, enormous, exalted, expectant,
extensive, extreme, famed, famous, fantastic, far-out, fine, gigantic,

good,
grand, gravid, gross, heavy, high, honourable, huge, illustrious,

immense,
important, large, leading, lofty, main, majuscule, marvellous,

marvelous,
mighty, monstrous, monumental, noble, notable, noteworthy, outstanding,
princely, principal, prominent, remarkable, renowned, serious, splendid,
strong, terrific, towering, vast, weighty, with child, wonderful,

zealous

or did you mean anagrams?

--
Regards,
Tom Ogilvy



"SURESH" wrote in message
...
i required your help in this regard.. it may be silly/hard? for you...

that.. if i wrote "great" in Cell A2, i want Great's synonyms in

B2....
and
also if there is any spelling mistake .. thats too want to know in C2

( or
Great)

thanks in advance
Great regards,
suresh tp









Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Synonyms - use with vlookup Roger on Excel Excel Discussion (Misc queries) 1 January 29th 09 03:23 AM
Problem accessing Oracle Public Synonyms from Microsoft Excel 2002 Sandeep Excel Discussion (Misc queries) 1 January 5th 05 09:31 AM


All times are GMT +1. The time now is 11:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"