>I've been given an Excel spreadsheet which contains links to some pictures. A large number of cells have the actual file name in the value. Unfortunately many of them show "Image" as the value but the picture displays when you click on the cell. If I try to capture the value of the cell
>xx = oxl.cells(row,col).value
>? xx -----> "image"
>
>If I hover on the cell I do see the file name and a message "Click once to follow. Click and hold to select this cell"
>
>does anybody have a way that I can capture the filename associated with the cell?
>
>thanks to all........Rich
Could you provide actual file or the file example ?