Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel URL in cell, How to read it into VFP
Message
De
24/08/2007 13:09:06
 
 
À
24/08/2007 13:05:09
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:
01250274
Vues:
31
I guess I don't have any sense! <g>
LOCAL oExcel as Excel.Application && to make intellisense happy

oExcel=CREATEOBJECT("Excel.Application")
oExcel.visible= .F.
oExcel.DisplayAlerts = .F.
lcFileName=[c:\vApps\vCMC\Imports\MasterList.xls]
oW=oExcel.Workbooks.Open(lcFileName)

oHL = oExcel.ActiveSheet.Range("O141").Hyperlinks
? oHL. 
NO intellisens for me.


Peter


>>Intellisence sometimes doesn't work on long chain of objects. In such case you have to create intermidiate object. Later you can combine it back if you want.
>>
>>oHL = oExcel.ActiveSheet.Range("O141").Hyperlinks
>>? oHL.
>>
>>
>Thanks
>
>Peter
Peter Cortiel
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform