My VB6 application creates an Excel spreadsheet.
Column H contains email addresses.
The cells in column H already contain the string texts of the addresses
(starting at row 5)
when the following is executed:
sCol = "H"
For iI = 1 To iMaxItems
sRow = CStr(iI + 4)
sRange = sCol & sRow
.ActiveSheet.Hyperlinks.Add Anchor:=.Selection, _
The spreadsheet is created all right, and all the email addresses are blue and underlined.
But when I click on one of them, I get:
"Cannot open specified file".
By the way, if it matters: Each cell entry is an address followed by a comma.
Because eventually the intention is to select a group to email.