hyperlink to view multiple picutres

[zoey2]

I have a hyperlink and I want to view all photos in a folder

I've tried

=HYPERLINK("d:\pics\Prob\*", "photo ")
=HYPERLINK("d:\pics\Prob\*.jpg", "photo ")
=HYPERLINK("d:\pics\Prob\firstpic.jpg", "photo ")

The first two say can't open specified file
The last one works and opens the picture in photo viewer as I wanted but I can not use the arrow keys to see the other photos in the folder.

How can I set up a hyperlink in windows 10 to view all pictures in a folder?

 

[Mentor82]

Hi,
In my opinion you cannot do what you request for. By using hyperliknk you can make a referrence only to one picture or to a folder only. If you want to run all the pictures out of the folder you should consider a VBA mactro, have a hyperlink to the folder and run a loop to open all pictures included.

Regards,
Sebastian

 

[pgc01]

Hi zoey2

I guess it depends on the program that you use to open the picture.
In my computer I have all the image files in windows to be opened by VLC.
I had no problems doing what you want.

This is the test I did:

I entered in a cell

=HYPERLINK("c:\tmp\pic\p00.jpg")

The folder c:\tmp\pic has some pictures of different formats (jpg, png, bmp, gif, also animated gifs).

Clicking on the hyperlink the picture p00.jpg opens with VLC and I can then use the arrow buttons in VLC to loop through all the other pictures (all formats) in the folder.