Language Translation In Excel
Apr 24, 2006
I have a list of English words (about 2500) that are listed in excel in column A. In column B I'd like the Portuguese translation.
The best I've got so far is to have a hyperlink in column B -
=HYPERLINK("http://www.ultralingua.net/index.html?action=define&sub=1&nv=0&searchtype=stemmed&text=XXXXXX&service=english2portuguese",
"ultralingua").
Where I've typed 'XXXXXX' this is the word that will be translated in
ultralingua.
Is there any way that XXXXXX can be replaced with the contents of a source cell i.e. so ultralingua translates the contents of one of the cells from column A? I'll the transcriibe the result into column B.
View 6 Replies
ADVERTISEMENT
Oct 2, 2012
I need to split the original sheet to many sheets according the language code, each language in a sheet.
Below the details of the original sheet:
First column for language name.
Language name always starts with two or three characters as shown:
ar
fa
fil-ph
gu
he
hi
id
[Code] .......
I need to split the original sheet to 21 sheets according to the language name ,the output sheet called by the language code name.
Also the first row in the original sheet is fixed in all extracted sheets.
LSPKG Name
New
Updated
Autotranslated
Uploaded
TopX
[Code] ........
View 1 Replies
View Related
Dec 17, 2006
I am trying to create a simple translation tool for my product catalog, which is in Japanese, to English.
I have the Japanese and the English terms listed in a file (say, File A) in Col A and Col B which will keep increasing every week.
I want to create a macro which goes thru this list and replaces ALL the Japanese terms to English in "ALL THE SHEETS OF THE PRODUCT CATALOG" (say, File B) .
I have created a button in File A so that when I press this button, I browse my computer, select the file (product catalog) to be translated, replace all the Japanese terms to English terms in ALL THE SHEETS and saves it under a different filename.
View 14 Replies
View Related
Dec 7, 2011
I have a list of numbers in a column. The column looks like this:
CodeA
1 5 7
1 2
3 4
2 6
4 5
I need the column to be translated using the code below, so for instance Row 1 would be Toys, BubbleGum, Cookies
1 = Toys
2 = Candy Canes
3 = GumDrops
4 = Chocolates
5 = BubbleGum
6 = Mints
7 = Cookies
Is it possible to count these individual items in the cells, even though there are more then 1 thing in a cell?
View 1 Replies
View Related
Mar 26, 2006
I have excel files which has text written in deutsche(german).
am trying to write a code which can convert this text to english.
have also found a reference from this forum
[url]
But this doesnt seems to be working for me.
View 9 Replies
View Related
Jul 25, 2007
i have a text file with the following data
12345
-----
A |xxxxx
A1 |.x...
A2 |..x.x
I need to get an output better on text (excell is limited with rows and the matrix can have up to 5000 rows and lines)
i tried to open the file with excel but every line is a string and i can't separet it
the output will be
A 1,2,3,4,5
A1 ,2,
A2 ,3, ,5
it will save me a lot of time
View 9 Replies
View Related
May 2, 2006
I have a cell in which I have the following data (for example):
<a href="http://www.trucks.com">Ford Trucks</a>
I need to export the sheet as a tab delimited txt file for import into another program. When excel saves the file as .txt, it add extra data so that the cell is represented as:
"<a href=""http://www.trucks.com"">Ford Trucks</a>"
Note the set of two additional inverted commas. This extra data interferes with the parsing of the data in the other program. I've tried formatting the cells to "general" and "text", however, it does not seem to affect the txt output.
View 9 Replies
View Related
Apr 3, 2014
i am very new to and admittantly can only use by running through the commands...i dont know how to run/use a macro with vba language...
so, i can easily set up a small macro run button that allows users to input a ''member number'' at any one time manually and it then selects the data behind that number and prints all relevant info/sheets etc,,,
HOWEVER, i dont know how to do an auto run selection in macro...so, rather than manually entering member 1, select, print, then manually enter member 2, select, print, then manually enter member 3 etc... i want to produce a macro that would automatically run the whole list of member numbers from 1 to 170 in order and print all their relevant info in one go...rather than manually entering the numbers which would take ages...
in a nutshell, select all (1 to 170), run all, print all...
View 1 Replies
View Related
Apr 24, 2013
how to change language of MS office.English language is not showing in options.Do I need to purchase language pack?I am using english language other than office.
View 1 Replies
View Related
Feb 29, 2012
I have a spreadsheet with thousands of rows of text that I need converted from one language to several other languages.
Is there a macro I can use that taps into some free service, running down my page and giving a foreign language conversion for each cell?
[URL]
View 14 Replies
View Related
Dec 9, 2013
Macro, I can make number to language. As example: 121 is one hundred one.
View 5 Replies
View Related
Sep 21, 2012
I have a sheet that the first words in the cells are in Arabic. How can I move the foreign words to another column? The number of words varies and they are all in the beginning of the cell.
View 7 Replies
View Related
Feb 23, 2014
How to convert a numeric value into Bulgarian words in Excel?
View 1 Replies
View Related
Jul 31, 2008
I would like to run a macro against a worksheet that will have variations in the amount of data (rows not columns). The column headings will always stay the same.
Once the basics in the macro run (formatting) I will need a certain statement to "lookup" values in a column (see values below) "count" them and give me a total.
I have attached a before and after file showing what I would like the macro to ultimateley do because it is so time consuming. Any assistance would be most appreciated.
.083=0-2hrs
.125-.50=3hrs-12hrs
.541-1.0=13hrs-1day
1.04-5=25hrs-5days
See SLA Response Days (column)
View 9 Replies
View Related
Aug 10, 2006
I need to select a print area that includes all rows to the last row with data in column A. What is the proper code for this? I tried the following (shot in the dark), and of course it doesn't work.
Sub Print_()
ActiveSheet.PageSetup.PrintArea = "A( Cell((65536).End(xlUp)):X1"
ActiveSheet.PrintOut
End Sub
View 9 Replies
View Related
Apr 30, 2008
A co-worker has an excel file that has both English and Chinese words in it. We need to convert the Chinese text to English. The contents of the files are sensative so I cannot share a copy. how to correct this?
View 2 Replies
View Related
Sep 8, 2006
I have users that submit a workbook quarterly. Many of the submissions contain name ranges that I need to remove. I wrote the below to delete the named ranges but encounter an error when the macro encounters a named range with the Kanji (Japanese) character set. How can I update this to delete these ranges as well?
Sub DeleteNamedRanges()
Dim ws As Worksheet
Dim NR As Name
On Error Goto ErrTrap
For Each ws In ActiveWorkbook.Worksheets
ws.Activate
For Each NR In ActiveWorkbook.Names
NR.Delete
Next
Next
ErrTrap:
If Err.Number = "1004" Then
Resume Next
End If
End Sub
View 9 Replies
View Related
May 1, 2009
I'm new to Excel and I'd like to know since it's more organized are the scripts better than other programming language scripts such as Ajax, JavaScript, Java FX, etc.
View 4 Replies
View Related
Mar 5, 2012
I have created a macro in excel 2010 which enable the file to save (extract) data into separate location and name. The vba code for macro is as follows: Question: How can I save this workbook with reference to the value containing in cell B2? (it is named temporary now - as defined in the code)
Sub aaa()
'
' aaa Macro
'
[Code].....
View 1 Replies
View Related
Sep 7, 2012
I have data in the following format-----
Name : XYZ
City : ABC
Place : sdfg
Error :
price : [X]
cost : [ ]
time : [ ]
[code]....
I want only name, place,desc and under error, i want that type which is marked cross in the brackets(In the above example it is price ) .
name, place,desc,error should be pasted to separate columns in second excel sheet.
View 1 Replies
View Related
Dec 7, 2013
I have some daily text files in a folder (so about 30 of them each month), which in the end of month, I need to open them up in excel, format them so that I can use the information for my analysis.
I would like to create a macro, to quickly open them all up at once and save them each individually in .xls or .xlsm format.
I am new to VBA and after some research online, I was able to have the files open with the following code. but now I don't know how to proceed further to save them one by one with the same name but in .xls or .xlsm format.
Sub Opentxtfiles()
Dim MyFolder As String
Dim myfile As String
[Code].....
View 2 Replies
View Related
Jul 9, 2012
Recorded macro. The hope is to insert a excel formatted table a set number of times. I have found a loop code that references a Cell A1 and repeats that amount of times. So if A1= 10. There should be 10 tables inserted. However on the second time there is a fault with the table name. I need the name to change each time the loop is run. ie Table1, Table2, Table3 etc up until the loop stops (A1 contents).
I am using excel for windows 2010. The macro that i have so far is below.
Sub LoopTest()
Dim n
Dim V
Range("A1").Select
V = ActiveCell.Value
[Code] ........
View 1 Replies
View Related
Mar 25, 2013
******** type=text/javascript>*********>******** type=text/javascript src="http://pagead2.googlesyndication.com/pagead/show_ads.js">*********>
I tried locking an excel document and i ticked a box that said protect structure, and then entered my password and now I cannot open the document. It is a white square on my desktop now with no options to do anything, it cannot even be attached to an email or deleted. This was on excel 2008 on a macbook.
View 1 Replies
View Related
Apr 15, 2014
Using EXcel 2013, Windows 8
I have an Excel worksheet with one column being e-mail addresses. Other columns are Christian names, etc
Ideally can I create a full Mail merge with Outlook using whatever data I want. But probably just e-mail address and Christian name?
Otherwise be able to send one e-mail to all the e-mail addresses, without a major re-type.
View 2 Replies
View Related
May 9, 2014
I need to write a code to create visio flow diagram with excel inputs(Excel 2007). Attached is the requirement.
Requirement_Specification.docx
View 1 Replies
View Related
Apr 19, 2010
I have an Excel 2003 file that contains hyperlinks to OneNote notebooks on a Sharepoint site. An Excel macro looks for these links and determines the full hyperlink address which is then assigned to a variable. An Outlook message is generated which includes the hyperlinks.
The hyperlinks work in the Excel file. I can also copy them from OneNote and manually paste them into an Outlook message and they work. However, when I obtain their full address and transfer that to the email through code, the links do not work. The hyperlink address from OneNote starts with "onenote:http" which is not recognized as a link.
If I can do this manually, there must be a way to do this with vba. Are there characters I need to include in the OneNote hyperlink address to make this work? Is there another way to transfer the working link from Excel to Outlook?
View 3 Replies
View Related
Apr 1, 2014
I am trying to adjust the below macro so that it will work in Excel 2010.
Sub OpenAndProcess()
Dim fs As FileSearch
Dim I As Integer
[Code]....
View 3 Replies
View Related
May 23, 2009
Is there any macro that can be used to convert data which have been converted from PDF to Excel. Currently I'm using a traditional way by pressing F2 and enter to convert the data to excel format. It's tedious ( since the data range is quite big) and crammed my finger.
View 9 Replies
View Related
Jan 11, 2013
I have seen excel zipped but it is visible as excel only. when i double click it it open a folder where same excel document is placed i have to double click it again to open it. how can i save the excel as zip having its same format.
View 1 Replies
View Related
Nov 25, 2013
I have defined a name for a data range in an excel file. Now I want to use the same name in different excel file. I tried through various sources but not sure how to do that. Current Soln: I am copying the data from the source file and re-defining the names for the range. But this seems to be duplicate and creates unnecessary space.
View 3 Replies
View Related
