MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

USEnglish vs. International(Languages)

  Asked By: Bennu    Date: Feb 18    Category: MS Office    Views: 1518

Here is a tough question for someone that can solve it.
I have an Excel Application that explicitly references "Sheet1", "Sheet2" and so
However, a person in Italy who executes this application has an error.
The error turns out that the sheets are created as in Italian(Italy) language as
"Foglio1", "Foglio2", "Foglio3" and so on.

How does one handle this for International Languages in VBA,
as well as USA(English) Language and still be able to
reference the sheets for any language ?



2 Answers Found

Answer #1    Answered By: Kanya Jainukul     Answered On: Feb 18

I can't test this but perhaps the codename of the sheet could be used
instead of the Name?

Check out Codename property in Help.

At the very least you could adjust the Codename property at design
time and use that in all your references  to that sheet, then the user
can put whatever name he chooses on the sheet tabs.

Answer #2    Answered By: Connie Wallace     Answered On: Feb 18

I *believe* that
the index number of the sheet... **as long as no sheets  have been
renamed differently** is the same as the number on the end of the
language string.

If *any* of the sheets have been renamed then all bets are off.

It's a question  of consistency. If you upset the pattern then the
pattern is gone.

I know at least one person  who renames all of his sheets in every
workbook prefixing them with a 2 character digit... 01_Summary,
02_Hospice, 03_Patients... and so on.

That can help sometimes but it sounds as though you have no control
over naming the sheets.

Sorry can't help more... Maybe if we get a bit more info on the

Didn't find what you were looking for? Find more on USEnglish vs. International(Languages) Or get search suggestion and latest updates.