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