Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Language independent Pivot settings
Hi
I am using the following code to set the PivotField in an existing Pivot table: Workbooks(filename).Sheets(sheetname).PivotTables( tablename)PivotFields(fieldname).CurrentPage = "(All)" However the "(All)" only works in english versions of Excel. Is there a way to set this field in a language independent way? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different Language Settings... | Excel Worksheet Functions | |||
Regional settings independent list separator in arrays | Excel Worksheet Functions | |||
How to write a language independent formula | Excel Programming | |||
DDE and MS Office Language Settings | Excel Programming | |||
Language settings | Excel Programming |