I have hyperlinks in a cell I have to read into a vfp field. The opposite of what you are doing
Thanks
Peter
>Peter, we use the following to create an excel hyperlink to a "local" picture. We assume that the pics are located with the xls file because was are shipping all files on a CD.
>
>
>*--- This will create a hyperlink of the
>*--- photo filename if a filename is present.
>*---
>IF ! EMPTY(temp.fp_file)
> lcPicFile = ALLTRIM(temp.fp_file) + ".jpg"
> .COLUMNS[15].Hyperlinks.Add(.columns[15], lcPicFile)
>ELSE
> .COLUMNS[15].VALUE = fp_file
>ENDIF
>
>
>
>
>>>Try
>>>
>>>oSheet.Range("O141").Item(1).Hyperlinks.Item(1).Address
>>>
>>>
>>>>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 get this error:
>>
>>member ITEM does not evaluate to an object
>>
>>peter
Peter Cortiel