Solved
 

I forgotten the GetHyperlinks


CString ls_cellPos;
ls_cellPos.Format("A%d", 3);
icl_hyperlinks = icl_oWksSheet.GetHyperlinks();
icl_hyperlinks.Add(icl_oWksSheet.GetRange(COleVari ant(ls_cellPos),
COleVariant(ls_cellPos)), "c:\\test.txt", covOptional, covOptional,
COleVariant("test"));

Tks

"Rui Oliveira" wrote:

C++ Excel automate, add hyperlink

How can I add a hyperlink in excel automation?

We have function €œHyperlink.Add€�, but I dont know what insert in first
argument.

LPDISPATCH Add(LPDISPATCH Anchor, LPCTSTR Address, const VARIANT&
SubAddress, const VARIANT& ScreenTip, const VARIANT& TextToDisplay);

Anyone have some sample code?

Thanks,
Rui