drag and drop files onto cells for hyperlinking?

This file will build a catalog of images in a directory you choose. A link to the image plus a thumbnail of the image will be shown. You can bring this up side-by-side with your other workbook and drag & drop the hyperlinks.

Go to Sheet2 for the buttons.

Originally Posted by 6StringJazzer

This file will build a catalog of images in a directory you choose. A link to the image plus a thumbnail of the image will be shown. You can bring this up side-by-side with your other workbook and drag & drop the hyperlinks.

Go to Sheet2 for the buttons.

Thanks a lot for your Macro 6StringJazzer. Unfortunately, when I press the Build Catalog button, an error shows up ( "the variable is not defined") . Could you also please make a little example of how is to work with it, for better understanding?
Thanks again,
Robert

Sorry, that was an error on my part. Try this.

Press the Build Catalog button. You will be prompted to select a folder. Then the tool will put a file name in each row of column A and a scaled-down image from that file in column B. The image will be stored as the original resolution so you can drag it bigger if you want.

Originally Posted by 6StringJazzer

Sorry, that was an error on my part. Try this.

Press the Build Catalog button. You will be prompted to select a folder. Then the tool will put a file name in each row of column A and a scaled-down image from that file in column B. The image will be stored as the original resolution so you can drag it bigger if you want.

vow! this is really interesting! I think for the next project we will change our way to rename pictures to a most intuitive one and make use of this great excel macro!

Thank you very much 6StringJazzer for a very well done work!

Originally Posted by 6StringJazzer

Just occurred to me, the macro assumes that everything in the folder is an image file, which of course may not be true. Let me know if you need any tweaks.

Hi again 6StringJazzer,

I扉e thought of another possible variant to approach this issue, not for now, but for next time. The thing is, for certain reasons we will make a pdf, with the set of pictures (a picture for every page in the pdf). Then now, what we have to do is hyperlinking every pdf page, this is = every picture in the pdf. Is it a way to create these sort of links automatically via makro? Just like the makro you did, but this time linking to the pages numbers ?

I扉e tried to find some info about how to do this but it seems like via the Hyperlink command, excel do not link directly to specific pages in the pdf.

I悲 really appreciate your help again.