This is a tip (Tom Ogilvy) on translating English functions to the language of your Excel.
The following macros were posted by Harald Staff (misc 2000-10-02 & 2000-10-27)
Just a tip: I use this little macro to insert english/american formulas into my norwegian Excel. It translates syntax to Norwegian and corrects the [list] separators. To enter an english formula (like copy-paste from these newsgroups), use this little macro and Excel translates to your language.
Sub InsertEnglishFormula() ActiveCell.Formula = _ InputBox("Insert and translate this formula:") End SubTo see the USA english formula of the active cell, use this little macro:
Sub EnglishFormula() MsgBox ActiveCell.Formula End SubRelated information on viewing formulas can be found on my Formula page (David).
The Following has not been testing under another language with is it's intended use.
I don't know how US comma delimitors would affect this so you might want to run a few tests -- I guess you would have to change them to your own after pasting and before hitting [OK]. Cells to the right of Column A should be blank to allow expansion across them if needed. Sub ShowEquivalentFormula() Dim USFormula As String USFormula = InputBox("Supply US version of formula," _ & Chr(10) & "Cell A1 will receive changed formula", _ "Translate formula", "=LEN(A2)") If USFormula = "" Then MsgBox "you chose CANCEL" Exit Sub End If On Error GoTo incomplete [a1].Formula = USFormula [a1].Formula = "'" & [a1].Formula Exit Sub incomplete: MsgBox "Error occurred while attempting to convert" _ & Chr(10) & USFormula & Chr(10) & Chr(10) & _ "Please ignore results in cell A1"
There was a page for code (code/substitute.txt for this page but found did not need to convert the URLs for direct usage in Babel Fish afer all.
Function URL_x(str) As String 'David McRitchie, 2003-07-14 for language.htm 'usage =personal.xls!url_x("http://abc.com") '-- turned out did not need on language.htm page URL_x = Application.Substitute(Application.Substitute( _ Application.Substitute(Application.Substitute(str, _ ":", "%3A"), "/", "%2F"), "=", "%3D"), "?", "%3F") End Function
Foreign language URL's translation is available now from basically any language into any other language with Google translate. Was using Babel Fish when I wrote this page handled English, Spanish, French, German, Italian, and Portuguese. I had started out on Lycos from Carnegie Mellon but learned about AltaVista later on from my brother.
It is now 2019 and Babel Fish has not been around for five years, but I have been Google Translate for many years now, and generally would use a bookmarklet to translate the current page from whatever language it is in into my own language(English). You can drag the bookmarklet(tr: translate current page) to your bookmarks and invoke it from there (there is nothing on this page that needs translation).
From Richard at Digital.com:
At Digital.com, we've published a "long read" on the rise and fall of Altavista's Babel Fish, which I thought make an "easy fix" to send your readers somewhere more useful than the random redirect to the Yahoo homepage. It covers everything from the birth of the first online translator (and the geek-friendly name!) through to its demise at the hands of Google Translate. You'll find the article here:- https://digital.com/about/babel-fish/
This is an old page, and we were all Microsoft MVPs and many of the sites have changed or disappeared as have Laurent's pages. An example of a site I needed to translate, Laurent Longre's site:
http://longre.free.fr/ (not found) (not found) automatically from French to English using Babel Fish (not found) (not found)
http://babelfish.altavista.com/babelfish/urltrurl?lp=fr_en&url=http://longre.free.fr/index.html (not found)
Once you do the translate it is hard to believe you are looking at a machine generated translation of Laurent Longre's page from French to English, linked to pages will also be translated, watch out for coding. Note: Laurent has some pages in English -- Excel add-ins (not found 404) [-- http://longre.free.fr/english/ --]
A smaller version of this is currently included at the end of my [index] page.
The Babel Fish translator has been used for some Fun and Games to artificial languages see Google Humor on my Fun Page.
Foreign language Function Dictionaries:
http://cherbe.free.fr/fonctions_XL.ZIP (site: Christian Herbé (not found 404) This Excel table also available in HTML format at (not found) « (not found) and is marked courtesy of Laurent Longre (not found)
Language Translations for Excel particularly for Dutch, posting by Eric van Uden, 2003-05-19, http://groups.google.com/groups?threadm=%23psBVcmHDHA.email@example.com (not found) get XLmenufundict (not found) «, Jan Karel Pieterse, zip file, available at http://www.oaltd.co.uk/mvp/ (not found) (links within not found) has a translation list of the Excel built-in command bars and controls and the Excel worksheet functions for the international user: English, Dutch, Deutsch, Japanese (!), French, Swedish
I think it is based on Ron's material on John Walkenbach's site
-- Help Context IDs -- http://j-walk.com/ss/excel/tips/tip89.htm (not found) updated (English only) for Excel 2000-2003 http://www.rondebruin.nl/id.htm (not found) on his own site.
Also see Norman Harker's function list, download at http://www.contextures.com/functions.html -- includes a Dutch translation (done by Ron de bruin) also some related notes on Ron de Bruin's site http://www.rondebruin.nl/id.htm (not found)
Please send your comments concerning this web page to: David McRitchie send email comments
Copyright © 1997 - 2004, F. David McRitchie, All Rights Reserved