ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   synonyms (https://www.excelbanter.com/excel-programming/338607-synonyms.html)

SURESH

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




Tom Ogilvy

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






SURESH

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








Tom Ogilvy

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











All times are GMT +1. The time now is 06:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com