Identify Japanese text

purnima

New Member
Joined
Sep 1, 2005
Messages
46
Hi,

I am writing a macro to identify Mincho characters in a document.
This I can do using the Find feature: search for font="MS Mincho".
But sometimes, some of the documents have text in Japanese and in such documents, spaces show up as small boxes. And even though the font for such spaces is MS Mincho, they are not captured by Ctrl+F. I believe this is because the language is Japanese here and not English.
I still have coded a macro to identify Japanese text in documents, but the problem is that it works very slow. And this is because I'm scanning each word to determine its language.

I would like to know if someone knows of a better and faster way to achieve this.

Thanks in advance.

Purnima.
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,224,885
Messages
6,181,574
Members
453,055
Latest member
cope7895

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top