ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't open picture file link in Excel, Error no program registere. (https://www.excelbanter.com/excel-discussion-misc-queries/156814-cant-open-picture-file-link-excel-error-no-program-registere.html)

Habanero Mike

Can't open picture file link in Excel, Error no program registere.
 
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

joel

Can't open picture file link in Excel, Error no program registere.
 
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




"Habanero Mike" wrote:

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



All times are GMT +1. The time now is 10:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com