ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Software language version discrepancies (https://www.excelbanter.com/excel-programming/376622-software-language-version-discrepancies.html)

Vlado Sveda

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