Naver Korean Dictionary/English Dictionary Search Tool_v1.02_20240201
We are distributing “Naver Korean Dictionary/English Dictionary Search Tool_v1.02_20240201” with one additional feature. When there is a typo in the search term, the method of outputting results was added as an option, and a function was added to output according to this option.
The outline of Naver Korean and English dictionary search tools and how to use them are summarized in the article below.
Overview of Naver Korean Dictionary/English Dictionary Search Tool
1. Request
The following comments were posted this Tuesday (2024-01-30):
* Comment URL: https://prodskill.com/naver-korean-english-dictionary-search-tool-update-20220708/#comment-387
2. Reflected contents
2.1. Example of a case where results are different from the search term
If there is a typo in the Naver dictionary search term, the search results for the closest word are displayed. For example, if you search for “premium,” the suggestions will display “Search results for premium” and the search results for premium will be displayed as follows.
At this time, it was confirmed that the contents of the Http Response JSON file included the following data.
![입력한 검색어와 결과표시 검색어가 다른 경우 Response JSON 데이터 예시](https://prodskill.com/wp-content/uploads/2024/02/image-5.png)
2.2. Add options and add features
The “Show results even if they are different from the actual search term” option was added as follows.
When this option is selected, the results are displayed the same as the previous version (v1.01), and when not selected, a function has been added so that “#NOT FOUND#” is displayed in the results.
Descriptions of options have also been added to the help content as follows.
![도움말 내용](https://prodskill.com/wp-content/uploads/2024/02/image-6.png)
2.3. Example execution result
If you select and run the “Display results even if they are different from actual search terms” option, the search results will be displayed the same as the previous version (v1.01), and additional search results will be displayed in column H (“Actual search terms”).
!["실제 검색어와 달라도 결과 표시" 옵션을 선택하고 실행한 결과 예시](https://prodskill.com/wp-content/uploads/2024/02/image-2-1024x750.png)
If you run it without selecting the “Display results even if they are different from the actual search term” option, “#NOT FOUND#” is displayed in the search results. Results are displayed in column H (“Actual search term”). Additional search terms are always output regardless of the option. do.
!["실제 검색어와 달라도 결과 표시" 옵션을 선택하지 않고 실행한 결과 예시](https://prodskill.com/wp-content/uploads/2024/02/image-3-1024x506.png)
3. Download
Select and download the “Naver Korean Dictionary, English Dictionary Search Tool_v1.02_20240201.xlsm” file from github below, or
https://github.com/DAToolset/ToolsForDataStandard
Alternatively, you can download directly from this URL.
Hello, thank you very much for helping me study English. Actually, I would like to ask if it is possible to modify it like this.
In English words, not only the first meaning but also the meaning of 2 3 4 5 6 is important, but in many cases, the Oxford dictionary that is parsed is missing the 3rd 4 5 6 meaning or only the noun meaning is written, etc. In fact, Dong-A Publishing or There are times when you need to look at a dictionary such as Supreme.
There is a meaning view by grade in the far right column, and if you look at this, you can see the meanings of the 1st and above at once. I would like to ask if it is possible to use this meaning view by grade to retrieve the meaning.
Thank you for always. I also just started studying VBA. I feel sorry for always asking questions. thank you
hello nice to meet you.
Thank you for your good comments.
I will have to test it to find out if I can get the “See the meaning of each grade” content.
It's going to take a while because it's very difficult for me to find time these days.
I will test it and see if it is possible and leave a comment.
thank you teacher. I'm just a beginner learning VBA, so I've made it difficult for you. Thank you so much for your consideration. Please ask when it is convenient for you.
I apologize in advance if you find it a bit difficult to understand, because my English is very bad.
Hello, your tool is really suitable for my situation. But I still don't understand why when I use version v1.02 an error message appears, it is here:
Run-time error '1004'
Method 'Range' of object '_Worksheet' failed.
At first I thought it was because the new version had an error, so I redownloaded version v1.01 and the error was the same. As for the message, in debug mode it points to this command line:
Dim sWord As String, oKorDicSearchResult As TDicSearchResult, oEngDicSearchResult As TDicSearchResult
Dim oBaseRange As Range
Set oBaseRange = Range(“Search Results Header”).Offset(1, 0) [it points here]
oBaseRange.Select
Can you show me where the error is and how to fix it?
Perhaps the problem is in the “Range(”Search Results Header“)” part.
This syntax means “named range” in Excel, and I'm guessing that the name of the range written in Korean is causing the error on your computer.
Try this
1. in Excel, click the “Edit” button at the top of the “Name Manager” window that appears when you press Ctrl+F3, and change the name to “Header”
2. change the part of the VBA code where the error occurs to the following
– Before: Range(“Search Results Header”)
– After: Range(“Header”)
Hope this works for you.
And please post comment when it works.