Excel is RightToLeft?
 

Hi all.

I know how to set the sheet to righttoleft.
How can I tell if Excel shows the menues from right to left (e.g. Hebrew
Excel)

TIA
Guy

Excel is RightToLeft?
 

On Mon, 8 Aug 2005 17:51:46 +0200, "Guy Cohen" wrote:

Hi all.

I know how to set the sheet to righttoleft.
How can I tell if Excel shows the menues from right to left (e.g. Hebrew
Excel)

TIA
Guy


When I set my regional settings to Hebrew, the Excel menus remain in English.

If you have a version that has Hebrew menus, can't you just look at the menus
and see?


--ron

Excel is RightToLeft?
 

Guy,
Even if you have Hebrew Excel, presumably you could have installed the
Office Language Pack and actually have English menus.
Why is it important to you ?

You could check the caption of a know menu item/button :
Application.CommandBars("Standard").Controls(1).Ca ption

NickHK

"Guy Cohen" wrote in message
...
Hi Ron and thanks for trying.

No - I cannot ask my vb program to look and see if the menues are in
hebrew
and only then generate reports ( VB has not got that feature yet ) :)

Any other ideas ?


Thanks
Guy Cohen

"Ron Rosenfeld" wrote in message
...
On Mon, 8 Aug 2005 17:51:46 +0200, "Guy Cohen"
wrote:

Hi all.

I know how to set the sheet to righttoleft.
How can I tell if Excel shows the menues from right to left (e.g. Hebrew
Excel)

TIA
Guy


When I set my regional settings to Hebrew, the Excel menus remain in
English.

If you have a version that has Hebrew menus, can't you just look at the
menus
and see?


--ron

Excel is RightToLeft?
 

Hi Ron and thanks for trying.

No - I cannot ask my vb program to look and see if the menues are in hebrew
and only then generate reports ( VB has not got that feature yet ) :)

Any other ideas ?


Thanks
Guy Cohen

"Ron Rosenfeld" wrote in message
...
On Mon, 8 Aug 2005 17:51:46 +0200, "Guy Cohen" wrote:

Hi all.

I know how to set the sheet to righttoleft.
How can I tell if Excel shows the menues from right to left (e.g. Hebrew
Excel)

TIA
Guy


When I set my regional settings to Hebrew, the Excel menus remain in
English.

If you have a version that has Hebrew menus, can't you just look at the
menus
and see?


--ron

Excel is RightToLeft?
 

Hi Nick
My VB program generates reports using Excel.
If the Excel is in Hebrew/Arabic I would like to align some of the texts to
the right, if not - to the left.

Thanks for trying...
Guy

"NickHK" wrote in message
...
Guy,
Even if you have Hebrew Excel, presumably you could have installed the
Office Language Pack and actually have English menus.
Why is it important to you ?

You could check the caption of a know menu item/button :
Application.CommandBars("Standard").Controls(1).Ca ption

NickHK

"Guy Cohen" wrote in message
...
Hi Ron and thanks for trying.

No - I cannot ask my vb program to look and see if the menues are in
hebrew
and only then generate reports ( VB has not got that feature yet ) :)

Any other ideas ?


Thanks
Guy Cohen

"Ron Rosenfeld" wrote in message
...
On Mon, 8 Aug 2005 17:51:46 +0200, "Guy Cohen"
wrote:

Hi all.

I know how to set the sheet to righttoleft.
How can I tell if Excel shows the menues from right to left (e.g.
Hebrew
Excel)

TIA
Guy


When I set my regional settings to Hebrew, the Excel menus remain in
English.

If you have a version that has Hebrew menus, can't you just look at the
menus
and see?


--ron

Excel is RightToLeft?
 

On Tue, 9 Aug 2005 08:57:36 +0200, "Guy Cohen" wrote:

Hi Ron and thanks for trying.

No - I cannot ask my vb program to look and see if the menues are in hebrew
and only then generate reports ( VB has not got that feature yet ) :)

Any other ideas ?


Thanks
Guy Cohen


I'm not familiar with Hebrew Excel. I take it is different from regular Excel
running on a system with the Windows Regional settings set to Hebrew.

If Hebrew Excel is a separate program, you should be able to use the Name
property of the Application object to see if your VB routine was called from
Hebrew Excel.

Or, if it's just a version of regular Excel, you should be able to use the
International Property to figure out which version of Excel you are using.

In either event, I think you should also be using the International property to
check on the Windows control panel regional settings.

You may need to have a copy of Hebrew Excel to test this out on.


--ron