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 RepliesI want to convert all the Arabic letters into English (ie. Translitertaion) Not translation. I have found the below sample code in google and I have just tested but it is not working
Const cyr = "123456789" 'the cyillic alphabet in order
Const lat = "abcdefghi" 'the latin alphabet in the same order
Function convertchar(inchar As String) As String
Location = InStr(cyr, inchar)
[Code]....
If I type any number in cell A1 and run the above convertcells, it is not converting to latin.
how to convert dates to text without using addon, using VBA. like 23/12/2013 to Twenty third december, two thousand thirteen,
View 1 Replies View RelatedI would like to share with you this VB Code
convert number to text ( Convert Numbers to Text.) I hope you like it
Add it to add-in to be able using it in all excel sheets.
I run excel 2010... I have xls file (see file attached) with both English and Non English characters.
When I save this file as xls or xlsx - everything is good, but when I save the file as CSV and try to open it later - I see that the English characters stays the same but the non English characters become gibberish.
How can I save a file (that include some non English characters) as CSV without loosing the non English characters? Is there a way to do that from within the excel 2010 menus? Or maybe there is an external tool?
Attached file : 913365454523.xls
a macro to convert this;
a
b
c
d
[Code]...
Into this;
x
a
9
x
b
[Code]...
So far I have the following, but this is not quite right!
[QUOTE][Sub ConvertRange()
Dim targetRowNumber As Long
targetRowNumber = Selection.Rows(Selection.Rows.Count).Row + 2
Dim col1 As Variant
[Code]...
/QUOTE]#
I want macro which export each excel column to new text file. The data in excel file is number. The column has only 5 rows that means each new text file should contain five lines of one column. It looks simple but couldn't manage to do macro for it. I have very big data set in one excel file, and have to be splitted into text files. The file name in new text files can be any kind as long as it can be in some sort of order for each export.
View 2 Replies View Related how to word it but if someone understands then please help. I have two excel data files namely Book1.xls & Book2.xls. Both files have different data in it. Both files contain macros. When these macros run the files become **FINALIZED** version.
Originally, I get the above files in my email as txt. attachments. I then move these two txt files to my desktop in a folder called Folder-1. Then I open these files as an Excel and save them.
Basically, I need to know if two txt files are sitting in a folder-1 on my desktop. What can I do or what can I clik that....those two text files get converted into excel automatically, including running that macro I talked about in the above paragrah.
To put it differently, if I have two txt files Book1.txt, Book2.txt in a folder, how can I automatically create an excel **FINALIZED**version which sits right next to their txt version.
i'm having a problem with a script I have (script is below). What i'm doing is running a script that displays files in a certain folder, those files are then displayed on sheet1 column O and are linked so when they are clicked upon, the file will open. I also have a combo box with a input range of $O$O. That puts the values in column O in the combo box. Now here is a problem and request.
Problem first, when I select the file names from the combo box, they don't open the file, all it does is display the file name in combo box and that's it. how to I get it to open up the file? Now for a request, I have another sheet that is almost exactly as the one i described above. The only thing different I want is when someone clicks on a file name from the combo box, instead of it automatically linking to the file, I want them to click on a button to display the file.
Sub HyperlinkXLSFiles()
ActiveSheet.Unprotect
Dim lCount As Long
Application. ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False
On Error Resume Next
With Application.FileSearch
.NewSearch
'Change path to suit
.LookIn = "c:Sec"
.FileType = msoFileTypeExcelWorkbooks
' .Filename = " Book*.xls"..................
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...
I have a listbox with 8 columns. Multiselect is enabled, and it must stay this way. As part of my program, after the user presses a command button, I need to use the row indexes of the selected rows in order to copy the selected information into an array which is then placed in a different listbox, and then delete the items from the original list. Pseudocode of what I want to do:
[Code] .....
But my understanding is that .ListIndex does not work this way with multiselect listboxes. I've tried searching for a solution for a while, but I cannot find one.
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.
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 RelatedI 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]
Macro, I can make number to language. As example: 121 is one hundred one.
View 5 Replies View RelatedI tried many ways to convert a CSV file into a formatted Excel (.xls) file via VBA. I have a file with 5 lines (header included) and about 10 columns (delimited by commas).
How can I format it via vba on button click action?
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 RelatedHow to convert a numeric value into Bulgarian words in Excel?
View 1 Replies View RelatedI 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)
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] ........
So I have table that consists of several columns describing a single transaction. I want a macro to translate the (potentially thousands) of rows into a single cell for each row on another worksheet.
The rows need to be formatted by transaction type. The problem is that I know nothing of excel syntax .
I was thinking something along the lines of a case loop, if possible:
Case D1 = BUY
Output("You bought ("C1") on ("A1") for the amount ("E1")")
Case D1 = SELL
Output("You sold ("C1") on ("A1") for the amount ("E1")")
etc.
How would I get that into workable excel code, if possible?
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.
I have US reporting package that e-mails a report, which I then run macros to put extract the required data, and pivot etc...
There can be anwhere between 1 and 15,000 lines of data.
The file is generated as a CSV file, with dates in the first column in the format mm/dd/yyyy. Other header information also has a "/" so it is impossible to do a text to columns.
I need to continue using UK dating format, so cannot change the Excel settings.
Can anyone provide me with VBA code to convert mm/dd/yyyy into dd-mmm-yyyy without it ignoring any dates where the dd is less than 12?
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
I have an excel file which I really need to encode non english characters as when I import it into our system all special characters return as �
The problem is I need it to work similar to how this works: Unicode to HTML converter
It only encodes standard text, leaving the HTML intact, and only converts non-english characters such as UTF-8 etc...
I have tried setting the encoding when saving to a CSV file as UTF-8 however still no luck.
How to display following, that the day and month will apear in English, w/o relation to current regional settings:
Format( Date, "Long Date") & ", " & Time
Let's say I have one column of;
1
2
3
4
5
6
7
8
9
What is the most efficient way to change this into '3-columns & multi-rows' like this?:
1 2 3
4 5 6
7 8 9
The actual list is a lot longer and numbers are not in order.
I have multiple rows within a cell separated by Alt+Enter, and would like to combine them as follows:
Desired Result
First
First
Name
Name
First Name
First Name
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
a2 needs to contain a number (multiple of 10 10-90) and then d2 must contain a formula that gives that number in word form.
I need to do the same thing in b2 and e2, only with a number 20-99 not neccesarily ending in 0.