The code (VB.net) writes a hyperlink to a cell
The original code is:
Code: Select all
xlWorkSheet.Cells(cnt, 1).Select()
xlWorkSheet.Hyperlinks.Add(xlApp.Selection, FilePathAndName, "", "", FirstName)
Code: Select all
MySheet.getCellRangeByName("A" & cnt).hyperlinks.add(FilePathAndName, "", "", FirstName)