I have upgraded to OWC10 (Office XP) and it now contains
hyperlinks in cubes.

==> I am able to set the field as a hyperlink by using the
==> following code:

dim pview
Set pview = pTable.ActiveView
pView.Fieldsets("Record Id").Fields(0).IsHyperlink = True

==> but cannot set its value with the following code I found. I am
==> using a pivot table not a spreadsheet for the data.

Sub Insert_Hyperlink()
dim pview
Set pview = pTable.ActiveView
Dim NewHyperlink
Set NewHyperlink = pView.Fieldsets("Record Id")
NewHyperlink.Value = pView.Fieldsets("Record Id").Fields(0)
NewHyperlink.Hyperlink.Address="http://myurl.blahblah.com=" &
NewHyperlink.Value
End Sub

Thanks in advance!!

--
Posted via http://dbforums.com