Image File Path for Linked Pictures
How did you create your linked picture ?
NickHK
"Lazzaroni" wrote in message
...
I am trying to return the full source path of image files for linked
images
in an Excel spreadsheet (msoLinkedPicture).
The following code does not work, but it demonstrates what I am trying to
do.
Dim oShape As Shape
For Each oShape In ActiveSheet.Shapes
If oShape.Type = msoLinkedPicture Then
Debug.Print oShape.LinkFormat.SourceFullName
End If
Next
Does anyone happen to know how to return a linked picture's source name?
|