>>>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.

http://support.microsoft.com/kb/163263

Tells that it existed even before Excel97.

"Additionally, the UsedRange property in Microsoft Excel 97 refers to only the occupied range of cells."
Cetin