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