HRESULT: 0x800A03EC

Nov 8, 2011 at 5:41 AM

Hi,

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

/Niels

Coordinator
Nov 8, 2011 at 6:59 PM
Edited Nov 8, 2011 at 7: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 :  http://www.made4dotnet.com/Default.aspx?tabid=141&aid=15 or changing your formula to be US English with commas and FALSE might help.

More ideas here http://msdn.microsoft.com/en-us/library/aa168494(v=office.11).aspx  and http://msdn.microsoft.com/en-us/library/aa537159(v=office.11).aspx and http://blogs.msdn.com/b/eric_carter/archive/2005/06/15/429515.aspx .

-Govert

Nov 9, 2011 at 6:09 AM

Thanks Govert. This solved it!