Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel URL in cell, How to read it into VFP
Message
 
 
À
24/08/2007 11:45:11
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:
01250265
Vues:
32
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.
>hyperlinks is an object but has no intellisens:
>
>CLEAR
>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)
>
>?oExcel.ActiveSheet.Range("O141").Hyperlinks   <<<---- returns an object but adding a dot shows no Intellisense
>
>?oExcel.ActiveSheet.Range("O141").Hyperlinks.Item(1) <<< --- ole eror code 0x8002000b invalid index
>
>
>
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform