Can't open picture file link in Excel, Error no program registere.

H

Habanero Mike

How can I open my Kodak pictures in a hyper linked fashion in Excel? I tried
this but I get an error of: "no program is registered to open this file" I
could probably change the "open with" in windows explorer but... this would
change for every picture I open up on my computer which I do not want to do.

Can anyone help me out there?

Thanks,
Mike


Can anyone help me out there?

Thanks,
Mike
 
J

Joel

I right click mouse on cell I wanted to add hyperlink. Then selected
Hyperlink and sel;ected the file I wanted to add.

I also did this using a recorded macro and got the following code
Sub Macro1()
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"C:\TEMP\Ferry 2.jpg", TextToDisplay:="C:\TEMP\Ferry 2.jpg"
End Sub
 
Top