I need to have Excel display images based on the file paths from another column. In a certain way:
column G shows the name of the folder
column H shows the name of the file(usually: 00, 01, 02, ...)
column I specifies the filetype ONLY if it is different from .jpg
The image should appear in column B in this way:
1. Glue the path from the columns G+H and add .jpg or take file name from column I
2. Link it (not paste!) into the cell, first making sure the hight is less than 350
3. Then making it less than 30 in width (the column will be slightly wider than 30)
4. Make the cell have the height not smaller than the height of a such-resized image. Often other columns will have a lot of text and therefore should not be resized, to keep the automatic height working on. This way the image is kept within the cell boundaries.
5. Center the image inside the cell
6. Lock the images inside the cells, so they move and resize with the cell (that is not moving around or stretching when the spreadsheet is filtered or sorted, or columns or rows are added)
I've found similar questions and the use of VBA, but I'm not smart enough to customize them.
column G shows the name of the folder
column H shows the name of the file(usually: 00, 01, 02, ...)
column I specifies the filetype ONLY if it is different from .jpg
The image should appear in column B in this way:
1. Glue the path from the columns G+H and add .jpg or take file name from column I
2. Link it (not paste!) into the cell, first making sure the hight is less than 350
3. Then making it less than 30 in width (the column will be slightly wider than 30)
4. Make the cell have the height not smaller than the height of a such-resized image. Often other columns will have a lot of text and therefore should not be resized, to keep the automatic height working on. This way the image is kept within the cell boundaries.
5. Center the image inside the cell
6. Lock the images inside the cells, so they move and resize with the cell (that is not moving around or stretching when the spreadsheet is filtered or sorted, or columns or rows are added)
I've found similar questions and the use of VBA, but I'm not smart enough to customize them.
