>I am creating a spreadsheet with emails in column 'H'
>when I look at the sheet entries in column 'H' are looking normal
>one I double click the cell in 'H' the email address in it turns into a mailto: type of hyperlink.
>
>How can I create this effect in my program
>oExcel.????
>
>
>Thansk
>
>
>Peter

Check http://www.tek-tips.com/viewthread.cfm?qid=1319252

From someone's answer - not tested yet:

oXL = CREATEOBJECT("excel.application")
WITH oXL
  .Workbooks.Add()

  WITH .activesheet
    .range("B2").Hyperlinks.Add(.range("B2"), "http://www.tek-tips.com/index.cfm")
    .range("B2").Hyperlinks(1).TextToDisplay = "Tek-Tips Home"
    .range("B:B").EntireColumn.Autofit
  ENDWITH 
  
  .visible=.t.
ENDWITH