>>I have an Excel sheet which stores amont other things URL to web sites
>>They show a ball like picture and whren you click on it IE navigates to the site
>>
>>I have to read it in in a VFP prg
>>but the value of the cell is blank
>>
>>how do I get to that value?
>>
>>
>>I tried oExcel.Range("O141").Hyperlinks.Item but that does not do it either. It's an object though.
>>
>>
>>Thanks
>>
>>Peter
>
>

>Local ox As excel.Application
>ox = Createobject("excel.application")
>With ox
>  .Workbooks.Open(m.lcXLS)
>  .Visible = .T.
>  With .ActiveWorkbook.Activesheet
>    For ix = 1 To .UsedRange.Hyperlinks.Count
>      ? .UsedRange.Hyperlinks(m.ix).Address, .UsedRange.Hyperlinks(m.ix).TextToDisplay
>    Endfor
>  Endwith
>Endwith
>

>Cetin

I get the error 'OLE error code 0x80020006: Unknown name' on the UsedRange command. using Excel97.