It is possible to list all the jpeg
images within a directory along with creating subdirectories. There are several ways to add images to an Excel spreadsheet
. The sheet can be removed providing the initialisation of the host variables with the exact values is done. A comment can also be added with the zoomed object providing correct coding has been set. The type of graphics file is very important here as it may work with jpeg
types of files, but may not be appropriate on png images for example.
Here is an application that lists all the *.jpg images in a directory, with the option to include subdirectories.
- This is the easiest way to incorporate images into a sheet.
- The display is flexible according to data that has been already compiled in the home sheet.
- Obviously you can remove the sheet providing you initialise the host variables with appropriate values.
- Another more elaborate version will be available in a later tutorial, using PictureBox instead of Images, allowing you to capture mouse events.
Version 3 initializes the comments with the zoomed images