Translate Entire Sheet by VBA (Multiple Languages) (without google translator)

[Mehmud Khan]

Hello everybody,
need a small help again guys...


Is there any way to translate the entire sheet in one click (contain multiple languages) without using Google Translator ?

I have attached an file, please refer the same and please help me in this guyz....
Till now I get many solutions from this portal.
Please help me this time as well...

thanks in advance...

 

[Marc L]

Hi !

Use a multi languages worksheet, a column = a language and enter words …​

 

[Mehmud Khan]

Thanks Marc for your interest into this case.
But I didn't understand clearly your suggestion.
Could you please explain in details please, if it is possible.

Thanks!
Mehmud Khan

 

[Marc L]

It was for a multi-languages worksheet but seems to not suit your case …

As Excel is not a translator, so how manually do you translate your data ?​

 

[Mehmud Khan]

Again thanks for your response sir Marc.

So, we can't translate multiple languages in one click!

But it could work for a single language in a excel sheet ?
I mean the entire sheet is in German language, with the help of VBA's it could be translate in English ? (replace word from German to English into same cell)

Hope you understand!

Best Regards!
Mehmud Khan

 

[Marc L]

So, we can't translate multiple languages in one click!

It is not what is written in my previous post !
As it depends clearly how smart is the workbook design
and on the answer to my question …
​

 

[Mehmud Khan]

thanks Marc.

If it is possible, so could you please create like that....

 

[Marc L]

So any answer ?‼​

 

[Mehmud Khan]

Hello Marc,
thanks a lot again...

I mean , can you please create a VBA excel file which can be used to translate the data from German to English.
Please...

Regards,
Mehmud

 

[Marc L]

No without any answer to my question …
And just read again post #2 !

Or use any Web translator …
​

 

[knotprav]

Hello everybody,
need a small help again guys...


Is there any way to translate the entire sheet in one click (contain multiple languages) without using Google Translator ?

I have attached an file, please refer the same and please help me in this guyz....
Till now I get many solutions from this portal.
Please help me this time as well...

thanks in advance...

Hi! I am looking for a solution to this problem too. Please let me know if you found the solution. Thank you!