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 10:03:42
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01250060
Message ID:
01250199
Views:
25
same error with ITEMS

>>>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
>
>It's probably Items not Item. Just a guess.
Peter Cortiel
Previous
Reply
Map
View

Click here to load this message in the networking platform