I am going nuts trying to create a spreadsheet using VB.Net. It all
seems to work EXCEPT for a column which has to contain a hyperlink.
I've spent more than 6 hours researching this but just haven't found
the right incantation. Here's the VB.Net code which puts a row of
data to Excel ...

astrRow(0) = oc.name
astrRow(1) = oc.tel
astrRow(2) = oc.tel2
astrRow(3) = oc.age
astrRow(4) = oc.mts
astrRow(5) = "=HYPERLINK(""" & oc.PhotoUrl & """)"
'astrRow(5) = oc.PhotoUrl
'astrRow(5) = "=HYPERLINK(""" & oc.PhotoUrl & """,""" &
oc.PhotoUrl & """)"
XLRow += 1
objSheet.Range("A" & XLRow.ToString, "F" &
XLRow.ToString).Value = astrRow

What I see in column F of the spreadsheet is ...

=HYPERLINK("http://www.confidentialwebsite.com/s_01.jpg")

Clicking on one of these cells generally does nothing. Sometimes if I
make a trivial editing change to one of these cells then Excel will
display the cell as a hyperlink but it is still unable to actually
follow the link.

PLEASE ... if you can help me resolve this I would sure appreciate it.

Thanks, Bob

Well ... after further butting of my head against the brick wall, the
wall finally crumbled. The trick was to use objSheet.Range().Formula
instead of objSheet.Range().Value.

I found the answer in VBA doc when that seemed to be the only place I
hadn't looked. I have no idea if it valid, in general, to use VBA
methods in VB.Net, but this Formula method seems to work.

Bob


On Sun, 28 Nov 2004 19:42:16 -0500, eBob.com
wrote:

I am going nuts trying to create a spreadsheet using VB.Net. It all
seems to work EXCEPT for a column which has to contain a hyperlink.
I've spent more than 6 hours researching this but just haven't found
the right incantation. Here's the VB.Net code which puts a row of
data to Excel ...

astrRow(0) = oc.name
astrRow(1) = oc.tel
astrRow(2) = oc.tel2
astrRow(3) = oc.age
astrRow(4) = oc.mts
astrRow(5) = "=HYPERLINK(""" & oc.PhotoUrl & """)"
'astrRow(5) = oc.PhotoUrl
'astrRow(5) = "=HYPERLINK(""" & oc.PhotoUrl & """,""" &
oc.PhotoUrl & """)"
XLRow += 1
objSheet.Range("A" & XLRow.ToString, "F" &
XLRow.ToString).Value = astrRow

What I see in column F of the spreadsheet is ...

=HYPERLINK("http://www.confidentialwebsite.com/s_01.jpg")

Clicking on one of these cells generally does nothing. Sometimes if I
make a trivial editing change to one of these cells then Excel will
display the cell as a hyperlink but it is still unable to actually
follow the link.

PLEASE ... if you can help me resolve this I would sure appreciate it.

Thanks, Bob