Hello everyone,
I have a file (Exemple.xlsm) containing 6 spaces reserved for images. By clicking once on one of the rectangles, the directory containing the images opens. I can then select the desired image and it is glued to the designated location, dimensioned according to the criteria defined in the VBA code, automatically selected ('Macro & instructions to paste a picture and the name of it (B11 ) ....) and the filename appears on the top left of the image. The images are JPG and prefix begins with 001, 002, 003, .... 999, 1000.
My problem is this: I would also be able to copy images automatically maintaining the predefined dimensions by typing the name of the image. For example: @ B11 E17 frame, I type in "B10", number: 032 followed by "Enter" and automatically 032.jpg photo will be pasted in the B11 @ E17 frame and the selection of the image will be made automatically without I manually select. The same thing for the other 5 areas for images. To avoid opening the directory containing the images after you press the "Enter" key, it will change the VBA code ('Macro & instructions to paste a picture and the name of it (B11) .. ..) to activate a rectangle with a double-click instead of a single click (present case).
If you have any questions, please contact me.
Thanking you in advance for your help.
Greetings,
Renaud22
Bookmarks