Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel URL in cell, How to read it into VFP
Message
From
24/08/2007 13:09:06
 
 
To
24/08/2007 13:05:09
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01250060
Message ID:
01250274
Views:
33
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
Previous
Reply
Map
View

Click here to load this message in the networking platform