Hi All..
We have report in macro which is going to used any many countries. This report having one chart report which works fine in US but same report does not work in Koria. There is a macro error..like below

for example, macro sentence described like as "ActiveSheet.PivotTables("PivotTable1").PivotField s("Sum of avs").Orientation ..."
but a cell of pivot table was automatically changed " Sum of avs" to " ÇÕ°è : avs".
because Korea use MS Excel with korean patch. So, we have to correct many macro sentences when we open the report.

Is there any solution for this? Please help...

Thanks
Ashish

Code for Ref:
    With ActiveSheet.PivotTables("PivotTable1").PivotFields ("avs")
        .Orientation = xlDataField
        .Function = xlSum
        .Position = 1
    End With