Excel VBA - Google Translate Function in Excel - PART 2 | XLStudio |

[@xlstudiovba]

Hello Friends, Hope you are doing well !!
Here is the another Google translate solution and this one is not with Excel VBA.. Its with using Power Query Custom Function. Please watch this video if you are looking for without VBA solution.
Video Link: th-cam.com/video/WJeP09WboDo/w-d-xo.html

[@jerrydellasala7643]

This was an awesome pair of videos. Great work. I have two issues. First, that's a lot of code to transcribe. It would have been helpful to post it in the text for the post at the least.
Also, I found that using:
Application.WorksheetFunction.EncodeURL(strSourceText)
in the strURL assignment instead of having to add it to the GoogleTranslate function in the worksheet worked just as well. I was able to copy the results from both Hindi (hi) and Chinese (zh-CN
) results to the Source Text columns as values and got the correct text back thus avoiding having to add it in the worksheet itself. Thanks for a great pair of videos!

[@mohammedaltair3695]

Thank you so much for this part 2 i was waiting for this part 2

[@ashishpahal3421]

Again Great stuff. Thankyou for figuring it out. 👏

[@inderjitwassi1420]

thanks - this and part 1 are great instructional videos

[@a.selezenev]

Hi, it is really cool, but is there workaround to make code work with company VPN?

[@xlstudiovba]

Use power query solution.. I have uploaded power query solution on my channel

[@a.selezenev]

@@xlstudiovba thank you!

[@mohammedaltair3695]

today i have learnt something new in it....

[@AminaShami-m1w]

Works brilliantly, thanks soooooo much! Very well done!!!!

[@tarek000137]

Its pretty good, working for me, thanks also, one more thing, can I automate font type and font size in the formula? Like for some translation, I want Times New Roman or for others I want Calibri font etc?

[@mealimmunisation6752]

Thank you great and nice job

[@chandukaveri1]

This is really wesome, Sir send vba code for this

[@xlstudiovba]

Email me .. will share the code

[@magoba44]

Hi great videos in my case I always got the translation in English regard the input on target Language

[@stephensibert7719]

Thank you very much!!! Is there a way that it can tell me what language was detected?

[@xlstudiovba]

Yes, we can do that. i am working on that and also i am working the video how we can translate without writing any VBA Code

[@nicksonscovers1835]

7:01 Could you paste this in the description? It would be very helpful

[@rajagopalramaswamy3178]

Thanks for the video. In turn, is it possible to do language translation without Google Translate and whether a whole of range of cells could be translated

[@xlstudiovba]

We can range of cells in one go.. but we have to Google translate, or any other translation website or API to translate

[@IbraHim-je4fe]

You are awesome!

[@75badrot]

HELLO
I do not recognise the ENCODEURL function
how come?
what am i doing wrong?

[@aajeshs2757]

Hi how to convert English alpha numeric to Arabic alpha numeric..Example ; No:20A,Hydrebad - 53421 - Into arabic - both alphabets adn numbers should be in arabic

[@vizznan]

HI, I am getting #Value in output when the function is used. I am on Office 365 windows 11

[@xlstudiovba]

Did you written the code exactly same ? And also check you should not be on company vpn network

[@vizznan]

@@xlstudiovba yeah the code is exactly the same and no vpn

[@dalya5125]

same issue have you found the solution ?

[@xlstudiovba]

I am also have same configuration, can you please send me the file which you written

[@dalya5125]

@@xlstudiovba can you give me your email ? so i can send it to you

[@Lifeislikethatwhynot]

bro link please