Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Direction problem in inserting strings using right to left language

Hi!

I'm trying to use InsertAfter to add string in a right to left language, and
right after it space and number.

The problem is that logically, Word adds the characters in the correct way
(Right to Left Text - Space - Number),
But in my view it looks like: (Right to Left Text - Number - Space).

I'm using something like:
Selection.InsertAfter "From: " ' "From" is replaced by a word in right to
left language)
Selection.InsertAfter " " & strMyString 'strMyString contains a string which
is actually a number, e.g. "1234"

problem is solved if I type the space manually, but I don't know how to
force VBA to write a "Right To Left" direction when it inserts the space
between the strings.

How can I force VBA to insert the space string in a Right to Left direction,
so that it will 'look' like it's between the two other strings and not just
logically "be" there?

Regards,
Amir.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Direction problem in inserting strings using right to left language

You post says you are using Word, so maybe better to ask this in a Word
group. This group is for Excel programming questions.

--
Regards,
Tom Ogilvy

"Amir" wrote in message
...
Hi!

I'm trying to use InsertAfter to add string in a right to left language,

and
right after it space and number.

The problem is that logically, Word adds the characters in the correct way
(Right to Left Text - Space - Number),
But in my view it looks like: (Right to Left Text - Number - Space).

I'm using something like:
Selection.InsertAfter "From: " ' "From" is replaced by a word in right to
left language)
Selection.InsertAfter " " & strMyString 'strMyString contains a string

which
is actually a number, e.g. "1234"

problem is solved if I type the space manually, but I don't know how to
force VBA to write a "Right To Left" direction when it inserts the space
between the strings.

How can I force VBA to insert the space string in a Right to Left

direction,
so that it will 'look' like it's between the two other strings and not

just
logically "be" there?

Regards,
Amir.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I change worksheet direction from right to left Haitham New Users to Excel 2 March 6th 10 08:28 PM
Change worksheet direction from right to left CheekyB Setting up and Configuration of Excel 3 November 27th 08 03:53 PM
Make left-to-right default direction hmm Excel Discussion (Misc queries) 1 March 18th 08 03:37 PM
i`d like to change the direction of office 2007 to left to right ahmed ramadan New Users to Excel 8 November 2nd 07 01:14 PM
Right-to-Left direction Ninad Excel Worksheet Functions 2 July 20th 07 07:35 PM


All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"