Dinesh Kumar asked about hyperlinks.
So, for instance, I have the following VBA code, and I’m trying to get the C++ code right – using YOUR wonderful XLL wrapers(ExcelX() ), but am not sure if the semantics of my call right.
Function GetURL(cell As Range, _
Optional default_value As Variant)
'Lists the Hyperlink Address for a Given Cell
'If cell does not contain a hyperlink, return default_value
If (cell.Range("A1").Hyperlinks.Count <> 1) Then
GetURL = default_value
GetURL = cell.Range("A1").Hyperlinks(1).Address & cell.Range("A1").Hyperlinks(1).SubAddress
The ancient xll API does not have as much functionality as VBA. If you look at a cell that has
the only thing you see is
Or maybe I'm misunderstanding your question.
multiply a number by 2
without setting up a SharePoint server. MS seems to be throwing money at OneDrive now. Technology marches on. What an amazing world we live in.