LinkBack URL
About LinkBacks
i need somebody to help me i need vba to use this function
DETECTLANGUAGE( cell)
i need somebody to help me i need vba to use this function
DETECTLANGUAGE( cell)
Last edited by 6StringJazzer; 10-30-2023 at 09:53 AM. Reason: fixed typo in title
What is the expected results?
Quang PT
Everything I found on the ".net" said it is not possible to use VBA and detect a language.
Several sites said you could use Google API to determine the language and plug the result into Excel.
Only one site said it was possible using an UDF which is presented below (untested here) :
Find the above at : https://answers.sap.com/questions/43...vba-code-.html
Please Login or Register to view this content.
If you are looking for something equivalent to Google Sheets' DETECTLANGUAGE() function (which appears to be connected to the Google Translate API), this youtube video appears to know something about it: https://www.youtube.com/watch?v=_J1g8IeM8v8
I'm not sure exactly how Google's pricing structure works, but I know that it is not always free to use their APIs.
Originally Posted by shg
It will probably be easier to just use Google Sheets.
https://docs.google.com/spreadsheets...it?usp=sharing
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
hell bro, i need to use the formula DETECTLANGUAGE( cell) in Excel to know the cell language like Google sheet with multi-database but my problem with Google sheet is not see results with a lot of cell lines so i looking for Excel Vba work like google sheet with formula DETECTLANGUAGE ( all language)
not work brother with alot of cell line , i tested but no result with big database this my problem with google shhet for this formula
Please see Logit's post #3 above
not work brother
6StringJazzer i tested but no result do you have another way brother or do you have Google Sheet vba formula working with Google Sheet but set timing between per request ,
waiting your feedback
Last edited by mohamedabdo; 10-31-2023 at 09:54 AM.
bebo021999 brother i am happy because you are here i want to work like Google sheet formula to detect language with all language source
Last edited by mohamedabdo; 10-31-2023 at 09:55 AM.
Whom are you addressing in each of these posts? Instead of using the generic 'bro', please use forum user names.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Ok sorry Mrsaligw noted
It's just AliGW, please.
Go back and add to each post the person you are addressing.
A response like "not work" is absolutely useless to your helpers, by the way.
Last edited by AliGW; 10-31-2023 at 09:53 AM. Reason: Typo fixed.
I posted a link to an example that used your data (what happened to your file attachment, by the way?). What exactly do you mean "no result"?
Good morning brother 6StringJazzer pls see attached not work no result after i added to my excel
Sorry habibi I think we are having some communication trouble. I recommended that you simply use Google Sheets instead of Excel because this feature is built in. I gave you a link to a Google Sheets with the DETECTLANGUAGE function on the data you provided. I do not understand the problem you are having with Google Sheets:
Logit provided a VBA solution in post #3 which I have not tested myself, and MrShorty provided a link in post #4 to a video that shows a solution, which I have also not tried.not see results with a lot of cell lines
If you try any of these solutions but they do not work, it is very important for you to tell us what is not working. Tell us what you expect to happen, and what happens instead. Shukrun.
The OP wants to detect the language of text in an Excel sheet. That is not what this function does; it returns the Registry system language setting for the user. I tried it and it raised an error, so defaulted to English.
pls give me access to try it, brother 6StringJazzer
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks