Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel URL in cell, How to read it into VFP
Message
 
 
To
23/08/2007 18:15:52
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01250060
Message ID:
01250065
Views:
27
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 have to read it in in a VFP prg
>but the value of the cell is blank
>
>how do I get to that value?
>
>
>I tried oExcel.Range("O141").Hyperlinks.Item but that does not do it either. It's an object though.
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform