Question HRESULT: 0x800A03EC when adding hyperlink to excel cell

[adrivetest]

I've been looking all over the net and can't seem to find out what exactly is causing the error that i'm getting when trying to add a hyperlink to a cell inside excel through visual basic 2008.

the line that is throwing HRESULT: 0x800A03EC :

(col & row) will create something like "A1"

xlSheetResult.Hyperlinks.Add(Anchor:=xlSheetResult.Range(col & row), Address:="", SubAddress:= _
xlSheetResult.Name & "!" & col & row, TextToDisplay:="Test")

Funny thing is , on some excel file it works without the exception.

 

[adrivetest]

I noticed something.

This exception only occurs if the excel had shared workbook enabled. Why is this happening?? Any other things that i did with my vb code such as drawing cells, highlighting etc won't cause any errors except for hyperlink