![]() |
Software language version discrepancies
Hi,
could somebody help me? I create Excel statistics from Lotus Notes, here is part of code: .... StatsSheet.xlApp.Cells(2, 8).Formula = "=YEAR(ActivityDate)" StatsSheet.xlApp.Cells(2, 9).Formula = "=1+INT((ActivityDate-DATE(YEAR(ActivityDate+4-WEEKDAY(ActivityDate+6)),1,5)+WEEKDAY(DATE(YEAR(Ac tivityDate+4-WEEKDAY(ActivityDate+6)),1,3)))/7)" StatsSheet.xlApp.Cells(2, 11).Formula = "=VLOOKUP(F2, OFFSET(OZ_Table, 0, 2), 9, FALSE)" ..... StatsSheet.Cells(TargetRow + 1, 3).Formula = "=SUM(" & xlApp.Range(xlApp.Cells(PrvyRiadok, 3), xlApp.Cells(TargetRow, 3)).Address(False, False) & ")" ..... StatsSheet.xlApp.Cells(TargetRow, 3).FormulaArray = "=SUM((" & xlApp.Range(xlApp.Cells(2, 2), xlApp.Cells(TargetRow - 2, 2)).Address & "=""Celkem"")*(" & xlApp.Range(xlApp.Cells(2, 3), xlApp.Cells(TargetRow - 2, 3)).Address(False, False) & "))" .... Everythink work fine except line with .FormulaArray if it is run on CZECH version of Excel. Excel internally translate formulas (YEAR, VLOOKUP, SUM ...) - but not in ..FormulaArray ;-( So I need to find out Language version of running Excel - is there any posibility to find it out ? Thanks to all in advance. Vlado |
All times are GMT +1. The time now is 01:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com