Languages support in Macros
 

Hi,
I'm trying to write out values from excel cells which have data from
various languages. I've installed all language packs on my client machine,
but the macro is erroring out trying to read the content. How can I make
macro read the content fine? Can some body help me here? Thanks for you help!

Regards,
Swamy

Languages support in Macros
 

Be more specific
reading content to do what?
which language is a problem?
post "reading" code

"Swamy" wrote:

Hi,
I'm trying to write out values from excel cells which have data from
various languages. I've installed all language packs on my client machine,
but the macro is erroring out trying to read the content. How can I make
macro read the content fine? Can some body help me here? Thanks for you help!

Regards,
Swamy

Languages support in Macros
 

Thanks for your response! I'm trying to read words from various languages
such as simplified chinese, traditional chinese, french, spanish and italian.
When I step in to the code and look for the value of the cell, I was seeing
question marks instead of the actual word and it is erroring out saying
'runtime error'. Hope this helps, if you need any further information please
let me know. Thanks!!

"Vacation's Over" wrote:

Be more specific
reading content to do what?
which language is a problem?
post "reading" code

"Swamy" wrote:

Hi,
I'm trying to write out values from excel cells which have data from
various languages. I've installed all language packs on my client machine,
but the macro is erroring out trying to read the content. How can I make
macro read the content fine? Can some body help me here? Thanks for you help!

Regards,
Swamy

Languages support in Macros
 

Again "read" has no meaning..

"the multi-lingual thing"'can get very complicated very fast
there are no easy answers but let's start with basics

where is the data, how did you put it there
does your code work for English?


for now just do english & French then expand
The issue is that Excel probably wants you to know what language the cell is
before you "read" it
Having the language stuff loaded is only a first step

Really should not be comingling languages in one database unless you have a
field to differenciate them and then may need to sort before tasking Excel


"Swamy" wrote:

Thanks for your response! I'm trying to read words from various languages
such as simplified chinese, traditional chinese, french, spanish and italian.
When I step in to the code and look for the value of the cell, I was seeing
question marks instead of the actual word and it is erroring out saying
'runtime error'. Hope this helps, if you need any further information please
let me know. Thanks!!

"Vacation's Over" wrote:

Be more specific
reading content to do what?
which language is a problem?
post "reading" code

"Swamy" wrote:

Hi,
I'm trying to write out values from excel cells which have data from
various languages. I've installed all language packs on my client machine,
but the macro is erroring out trying to read the content. How can I make
macro read the content fine? Can some body help me here? Thanks for you help!

Regards,
Swamy