Nov 8, 2011 at 4:41 AM


Any idea why I get exception "HRESULT: 0x800A03EC" from the following code


Excel.Application app = (Excel.Application)ExcelDna.Integration.ExcelDnaUtil.Application;

Excel.Range activeCell = app.ActiveCell;

string formula = @"=Dump(GoogleAnalytics(""ga:39239577"";""ga:visits,ga:timeOnSite"";""2011-11-01"";""2011-11-07"";"""";"""";"""";"""";1;50;FALSKT;FALSKT))";//wizard.Formula;
activeCell.Formula = formula;

formulas such as "=2+2", "=Dump(2)", "=Dump(Dump(2))" works fine. Also entering manually the formula above in Excel works fine.

Best regards


Nov 8, 2011 at 5:59 PM
Edited Nov 8, 2011 at 6:01 PM

Hi Niels,

I think you have a locale issue. Your formula with the ';'s between arguments and words like 'FALSKT' make me think you are trying to enter a locale-specific formula.

You'd have to experiment a bit, but either setting the thread locale explicitly, link this link explains : or changing your formula to be US English with commas and FALSE might help.

More ideas here  and and .


Nov 9, 2011 at 5:09 AM

Thanks Govert. This solved it!