Excel is RightToLeft?

[Guy Cohen]

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

 

[Ron Rosenfeld]

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

 

[NickHK]

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).Caption

NickHK

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

 

[Guy Cohen]

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

 

[Guy Cohen]

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

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).Caption

NickHK

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]

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