Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel URL in cell, How to read it into VFP
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01250060
Message ID:
01250242
Views:
29
Peter, we use the following to create an excel hyperlink to a "local" picture. We assume that the pics are located with the xls file because was are shipping all files on a CD.
*--- This will create a hyperlink of the 
*---    photo filename if a filename is present.
*---
IF ! EMPTY(temp.fp_file)
   lcPicFile = ALLTRIM(temp.fp_file) + ".jpg"
  .COLUMNS[15].Hyperlinks.Add(.columns[15], lcPicFile) 
ELSE
  .COLUMNS[15].VALUE = fp_file          && Photo Name
ENDIF
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform