how to insert the path of an image rather than the actual image itself (in excel 2010)

[lrussell5]

I need to find an easy way to locate an image on my server and upon selection rather than inserting the actual image I need to insert the image path. e.g. "s:\images\highres\green\1234.jpg"

Any ideas would be very much appreciated!

 

[Slizer6893]

Umm VBA code?

Sub RetrieveFileName()

Dim sFileName As String
 


    sFileName = Application.GetOpenFilename


    If sFileName = "False" Then Exit Sub


    Range("B4") = sFileName
        


End Sub

You can even add a nifty button into the sheet and just link it to this macro. Should just display the file name ("B4") can be changed to wherever you want it displayed.

 

[lrussell5]

Thanks allot Slizer that is just what I was after, any idea how I can copy the button / code so that i can paste it down the sheet?

 

[Slizer6893]

Umm lets make this easier on you

Change Range("B4") = sFileName to ActiveCell.Value = sFilename

This will make the current cell be what has the filename added.

Next lets create a short-cut I am going to use Ctrl+W

Go to developed tab, click macros, click our new macro, options, set shortcut to Ctrl+W