Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Windows version language and Excel version language | Excel Programming | |||
Can I download Microsoft Query? Missing software for my Version. | Excel Discussion (Misc queries) | |||
Determining Language Version of Excel | Excel Programming | |||
need to find a software version matrix utility | Excel Programming | |||
language version excel | Excel Programming |