Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel URL in cell, How to read it into VFP
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01250060
Message ID:
01250251
Vues:
26
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          && Photo Name
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform