translation

Hello, I am stuck trying to solve what may be a very simple problem. I understand logically what needs to be done I just don't have the knowledge for the best way to handle this much data and not make excel crash. I am currently limited with no access to utilize Pandas to solve this even...

In the previous article of this series, Power Query vs. Google Translation API - Part 2, we discussed how to make more effective Google Translation API calls by combining all rows as a whole text with a delimiter and send it to the web server in a single batch. In this last article of the...

I'm thinking of upgrading from Office 2010 to 2019. I need to know if I'll still be able to read and edit docx / docm and xlsx / xlsm files created with Office 2010 read/edit in Office 2019 and files created in Office 2019 (Except new funcitons, of course) read/edit in Office 2010, without any...

Hi all, I have a Workbook with one sheet called "Translation" with a translation table. There are 1.300 rows in this table, with words translated from English to Spanish, starting in cell "A1" <tbody> English Spanish Assets Activo Liabilities Pasivo </tbody> What I need is a code that...

Hi, I am working on a translation of part numbers from provider's to my company's standards. Provider's part numbers contain several words/numbers divided with spaces (all in one cell) - and my code translate them word by word by using vlookups from other sheet. So, the part number (product...

Hi there - could someone please tell me whether it is possible in Excel 2016 to have English words in say column A and a Spanish translation row by row in column B? I presume it probably isn't possible as I can't see anything about it in help.

Hi All So after lots of hurdles getting a new report sorted based on a data dump from a translation tool (over 50,000 rows per month) I've managed to get through pretty much every hurdle but this one. I can sum the number of words against each language, budget etc including a date range...

Hi my problem is Translation reserve in balance sheet and how to put it in powerpivot. I am consolidating a group of 10 subsidiaries and some have different functional currencies. I need to translate the balance sheet accounts to FX rate at the last day of the month and the P&L accounts to...

Hi everyone, I am a translator dealing on daily basis with several excel files which share almost the same structure and I am trying to come up with a series of advanced macros that can automatize multiple and redundant tasks I have to perform in each of them. Unfortunately, my knowledge of...

Hi I am wondering if there is a way with VBA to extract words from online web dictionary in two languages the word and its meaning with all of the pages into microsoft excel , Is there a code or can someone make it please :( Example of site : http://www.billydilly.com/en/english-arabic/a

Hi Folks, Here is a macro for word to word translation. Sub macc() Dim d() As String Dim myValue As Variant myValue = InputBox("Input Cell ID") d = Split(Worksheets("Titles").Range(myValue).Value, " ") For Each i In d a = Application.WorksheetFunction.VLookup(i...

Hi, I am new in this forum, but have monitored long time and have become a big fans of it. This forum had helped me a lot in vba excel problems. However this time I couldn't find any answer for my new issue to use translation.babylon.com I have function which work perfectly with google...

Hi there, I am COMPLETELY new to this board, and still a noob on most features in excel.. I came across this document: EASC_audit_Questionnaire.xls and would like to know if anyone can help me with understanding the "LANGUAGE" macro function in it. You will see there is a language selection...

I am trying to rearrange a report so it can be used in a differnt department. They only need certain information, and one column of info contains a five digit code that needs to be translated into an address. I would like to create a macro that will delete all unwanted columns, Then insert a...

Hi, for people using their Excel in other languages than English - Excel 2007 functions and their descriptions in 14 languages: http://www.piuha.fi/excel-function-name-translation/ Why? I needed an updated look-up table because at home I'm using my Excel 2007 in Finnish and I don't have a...