| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheets("Sheet1") for foreign languages
Hi,
The line: Set xlSheet = xlBook.Worksheets("Sheet1") fials in my application since my version of excel is in swedish and uses Blad1, Blad2, Blad3 etc. I'm not sure what language my customers use. What alternative can I use to Worksheets("Sheet1")? Thanks, Barry. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Worksheets("Sheet1") for foreign languages
Yes, it will fail because "Sheet1" refers to the text that appears in the WS
tab and as such any wrong text would fails (but Worksheets("Blad1") would succeed). If you do not know the name, you can use the index: Set xlSheet = xlBook.Worksheets(1) Or maybe look into using the .CodeName. NickHK wrote in message ups.com... Hi, The line: Set xlSheet = xlBook.Worksheets("Sheet1") fials in my application since my version of excel is in swedish and uses Blad1, Blad2, Blad3 etc. I'm not sure what language my customers use. What alternative can I use to Worksheets("Sheet1")? Thanks, Barry. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check the "Windows Regional Languages" setting? | Excel Programming | |||
| Windows "Region & Languages" ComboBox Issue | Excel Programming | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
| Pivotitems("(Blank)") in foreign language | Excel Programming | |||
| Sheet1 object not Worksheets("Sheet1") | Excel Programming | |||
Linear Mode
