View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lazzaroni Lazzaroni is offline
external usenet poster
 
Posts: 55
Default Get Path for Linked Pictures in Spreadsheet

Does anyone know how to return the full path of the file to which a linked
picture in Excel points to?

I use the following code to insert images into my sheet:

Set oPicture = ActiveSheet.Shapes.AddPicture(sFilename, LinkToFile:=msoTrue,
SaveWithDocument:=msoFalse, 10, 10, 100, 100)

I need to be able to get the filename of the picture that Excel is linking
to after images have been inserted into a spreadsheet.

Thank you for your help.